Frisbeeman
New Member
- Joined
- Sep 22, 2022
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
I would like to know if there is a way to mark or identify a cell so I can return to that cell later in an Excel macro. The cell I want to return to varies as the macro executes. So I can’t use “E5” for instance. The macro works down data in a spreadsheet looking for a specific value. When it finds that value it copies nearby data to a different location. I need the macro to return to the cell where it found that value so it can continue to work down the worksheet. Does VBA have some sort of cell location variable that can be set before copying the adjacent data, going off to paste to the copied data in the data collection area such that I can return to where it left off?
Thank you in advance.
Thank you in advance.