Thread
:
cell address
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
cell address
have a look at
..offset(-1,-1)
--
Don Guillett
SalesAid Software
"Kate" wrote in message
oups.com...
Hi,
I have a macro that does some stuff and selects a cell using
cell.address
But the cell I want is then actually 1 row down and 1 column to the
left.
Because cell address is a string, I can't go Range("A" & myCell + 1),
so what should I do?
Thanks
Kate
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett