Thread: Range Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jsd219 jsd219 is offline
external usenet poster
 
Posts: 68
Default Range Offset

Hi all, can anyone help me with this line:

cell.Offset(1, .Range "G").Value = "x"

I am trying to offset a row to a specific column

this is what the original line read:

cell.Offset(1, -5).Value = "x"

I was hoping to use a range letter instead of a number.

God bless
jsd219