Thread: cell address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kate[_2_] Kate[_2_] is offline
external usenet poster
 
Posts: 9
Default cell address

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