Thread: Macro to select cell based on formula
View Single Post
 
Old 09-22-2017, 09:04 AM
mreynolds1775 mreynolds1775 is offline Windows 10 Office 2013
Novice
  
Join Date: Sep 2017
Posts: 12
mreynolds1775 is on a distinguished road
Default
Peco, et. al,

Thanks for the help. I've been able to get the cell next to the last cell by using the following VBA:

Code:
Selection.End(xlToRight).Offset(0,1).Select
now that I have that cell selected, I can enter the desired formula. I however want to paste that formula through the remainder of the rows... problem is I don't want to type in a specific range, I want to use the range associated with the selected cell...

any ideas how to use an xlToBottom, but selecting all cells between the two ranges? In example B2:F2
Reply With Quote