View Single Post
 
Old 09-20-2017, 11:53 PM
mreynolds1775 mreynolds1775 is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2017
Posts: 12
mreynolds1775 is on a distinguished road
Default Macro to select cell based on formula

Hello all,

I record macro's the lazy way, but recording them. Typically this is fine as all actions are recorded by the mouse controls, but I would like to have the first step in the macro select the last cell containing a value in a row, then selecting a vertical range below that cell.

Any idea how to attack this?

Thanks in advance
Reply With Quote