View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default code to go to start of line

I need code to go to the first cell of the given row I am in, without knowing
how many columns over I am when I run the macro. In other words, a user is
going to be told to place their cursor on a line, and then run a macro. The
macro will rely on getting to the beginning of the line, then going over to
the 33rd column.

Alternative (and maybe even better) would be to be able to say that I want
the activecell to be the 33rd column (column AH), on the line from which the
macro was launched.

Either or both of these would be greatly appreciated. Thx.
--
Boris