View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kiwis kiwis is offline
external usenet poster
 
Posts: 24
Default How to move to column B1 from column Z1

Hi

my current cell is at column z1, i check for a condition,
if true then i move to column b1 to get the data, if not true, i move
to
next row & then test again.

how do i move to column b1 from column z1?

Do i use the offset function ?

Thank you for any suggestion provided.

kiwis