A
Alan
How do I say "go down one cell from where I am" in VBA code?
Thanks, Alan
Thanks, Alan
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Leo Heuser
Alan
E.g:
ActiveCell.Offset(1,0)
E.g:
ActiveCell.Offset(1,0)
J
JE McGimpsey
One way:
Activecell.Offset(1, 0).Select
another
ActiveCell(2, 1).Select
Activecell.Offset(1, 0).Select
another
ActiveCell(2, 1).Select
A
Alan
JE said:One way:
Activecell.Offset(1, 0).Select
another
ActiveCell(2, 1).Select
Many thanks!
Alan
C
Cutter
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)
return to the original sheet (but without having to name the origina
sheet)
J
JE McGimpsey
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
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
C
Cutter
Ok, I'll give it a go. Thanks for your help and advice