Hi

have the following line in a macro, but now need it to go to column "A" all
the time to pick up some data, how do I force it to a specific column, but
stay on the same row?

Just to confirm the "rng.Address" could be anything from column B ~ X

Range(rng.Address).Offset(rowoffset:=0, Columnoffset:=2).Activate