Relative reference and macros

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

How do I say "go down one cell from where I am" in VBA code?

Thanks, Alan
 
One way:

Activecell.Offset(1, 0).Select

another

ActiveCell(2, 1).Select
 
What code would you use to go from one sheet to a named sheet and the
return to the original sheet (but without having to name the origina
sheet)
 
I would almost never "go to" another sheet. For example:

Sheets("Sheet2").Range("A1:J10").Copy Destination:= _
ActiveSheet.Range("B13")

copies from Sheet2 to the active sheet without ever changing the
selection. Using the range object directly makes your code smaller,
faster, and IMO, easier to maintain.

However, to do what you're asking:

Dim shOriginal As Worksheet
Set shOriginal = ActiveSheet
Sheets("Sheet2").Select

'Do whatever

shOriginal.Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Relative Macro 6
Macro Relative Cells 3
Word to Excel: Export comments with text and line number 0
Macro to extend formulas 4
Error message refers to Name that can't be found 1
Narrative Comment with a Cell Reference 1
convert relative cell references to absolute cell references via amacro? 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top