ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 733
- Office Version
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
Hello - Having an issue modifying the below VBA to work when NOT on the sheet. When attempting to remove activate/select usage I cant seem to get the below to work when not on the sheet. is someone able to help? The problem is I am not on the "compare" sheet right before the action so it tries to paste formulas down on the sheet i dont want it to. then trying to see how to eliminate that last "select."
VBA Code:
Dim UsdRws As Long
'paste formulas down in Compare
Sheets("COMPARE").Range("F13:U13").Select
UsdRws = Range("A" & rows.count).End(xlUp).row
If UsdRws > 13 Then Range("F13:U" & UsdRws).FillDown