macro to paste many variables into a cell (1 Viewer)

smiler44

Registered User.
Local time
Today, 08:27
Joined
Jul 15, 2008
Messages
641
my mind is blank.

BH, CD, EF RC are all populated variables
I want to paste the contents into a cell, something along the lines of

activecell.value = BH & " " & CD & " " & EF & " " & RC
but this gives be an object required error
I've tried sheet1. at the beginning but this too is wrong

I cant believe I cant do this.

please can you help me?

smiler44
 

smiler44

Registered User.
Local time
Today, 08:27
Joined
Jul 15, 2008
Messages
641
sussed it, still got to get it right but I have it all but cracked

smiler44
 

Users who are viewing this thread

Top Bottom