PDA

View Full Version : Using Selection.Address



Rasm
11-28-2011, 05:17 AM
I highlight say cells B3:B8 - next I trap the cells by using "Selection.Address" - Now want to place a string (same string) in all the trapped cells - I tried



Selection.Address = Pcode


Where Pcode is my string - but it does not work - any help would be appreciated - I am hoping I dont have to do a loop.

Thanks
Rasm

Rasm
11-28-2011, 05:20 AM
ahhh - got it


Selection.Value = Pcode