macro to paste many variables into a cell

smiler44

Registered User.
Local time
Today, 20:43
Joined
Jul 15, 2008
Messages
690
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
 
sussed it, still got to get it right but I have it all but cracked

smiler44
 

Users who are viewing this thread

Back
Top Bottom