I have about 15 columns of data in a spreadsheet. I need to select the data in two columns to format it.
How do I select the ActiveCell and the cell in the next column.?
If D6 was the activecell, Range("D6:E6").select works as it selects the two cells that I want. How do I do it using ActiveCell. The code below does not work.
How do I select the ActiveCell and the cell in the next column.?
If D6 was the activecell, Range("D6:E6").select works as it selects the two cells that I want. How do I do it using ActiveCell. The code below does not work.
VBA Code:
ActiveCell.Resize(0, 1).Select
Range(Selection, Selection.End(xlDown)).Select