Mr_Mod
09-13-2011, 06:41 PM
Hi,
I would like to know how i would go about placing some text into a cell, for example Column "D" and paste the text "Hello World" utilising the same or similar VBA code as listed below.
What would the rest of the code be, have tried various different ways to just print text but none seem to work
wbS.Worksheets("WS2").Range("D65536").End(xlUp).Offset(1, 0).PasteSpecial Paste
Im really new to VBA and learn by experimentation. MS help is next to useless.
I would like to know how i would go about placing some text into a cell, for example Column "D" and paste the text "Hello World" utilising the same or similar VBA code as listed below.
What would the rest of the code be, have tried various different ways to just print text but none seem to work
wbS.Worksheets("WS2").Range("D65536").End(xlUp).Offset(1, 0).PasteSpecial Paste
Im really new to VBA and learn by experimentation. MS help is next to useless.