excel macros

  • Thread starter Thread starter John Morris
  • Start date Start date
J

John Morris

In early versions of excel you could move to a new cell
with the command SELECT("RC[1]"). What is the command in
Visual Basic macros for Excel XP. HELP!!
 
John said:
In early versions of excel you could move to a new cell
with the command SELECT("RC[1]"). What is the command in
Visual Basic macros for Excel XP. HELP!!
Click to expand...

In VBA:

ActiveCell.Offset(r,c).Select

Where r (row) and c (column) are numbers or evaluate to numbers.
Regards,
 
Thanks for your help. That did the trick for one part of my macro but I
need to move the back to column A and that formula will not take a
negative number. Any Ideas?
 
John,

What Beto gave you should work but if you're always looking to
go back to Column "A" you might just try:

Range("A" & Activecell.Row).Select

John
 
John said:
Thanks for your help. That did the trick for one part of my macro but I
need to move the back to column A and that formula will not take a
negative number. Any Ideas?
Click to expand...

AFAIK, you *can* use a negative integer. I succesfully tried giving
negative offsets.
Regards,
 
Back
Top