Solved: Placing text in a next empty Cell with VBA

[Mr_Mod]

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.

[mancubus]

wbS.Worksheets("WS2").Range("D65536").End(xlUp).Offset(1, 0).Value = "Hello World"




Range("D12").Value = "Hello World"




Range("D12") = "Hello World"

[Mr_Mod]

Many thanks again,
I actually tried so many combination's but never this one.

[mancubus]

you're wellcome.

please mark the thread as "solved" from "Thread Tools" dropdown on top of the page.