If your "H1" is on the ActiveSheet, yes. But it's always better to
explicitly indicate which sheet.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"mushy_peas " wrote in message
...
Say i have
Dim Current
Dim Last
and i had a cell with a number, how do i set Current to be equal that
that value. isnt it:-
Current = Range("H1")
or am i just being a noob
Thanks
---
Message posted from http://www.ExcelForum.com/