Stuck on Relational Cell Macro
Hello - needing some help on a Excel2007 macro I'm trying to create. I'm not an expert at it so may be a simple answer (hopeflly)... In this macro, I'm trying to copy and highlight a range of cells by using my left/right arrows incombination with shift and ctrl but since the data can be various sizes, I need to ensure it is not pointing to a specific cell location. An example of what I'm trying to higlight:
Column A | Column B;
Row 1 data Sum formula (to copy)
Row 2... data
Row 50 (as an exammpl)
1. Have a sum I'm trying to copy from Column B:1
2. Wanted to do a macro that captured:
(a) Go Left one cell from B:1 (to A:1)
(b) Then do CTRL+Down to go to the last entry row populated
(c) Go Right one cell (to go back to column B)
(d) Then do SHIFT+CTRL+Up to highlight All of Column B
(e) Then go SHIFT+DOWN 1 cell to B:2 so B:50 to B:2 is all highlighted to paste
Now that I'm using relative and non-relative on the "Stop Macro" box, it's not capturing the last (e) for some reason and the macro cannot paste since it is still capturing the cell I'm copying from.
Here is the actual macro:
Selection.Copy
ActiveCell.Offset(0, -1).Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Range("A1").Select
Range(Selection, Selection.End(xlUp)).Select
ActiveCell.Offset(-82, 0).Range("A2:A83").Select
ActiveCell.Activate
ActiveSheet.Paste
Can someone help?
Many thanks!
Lil