willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
I have conditional formatting in a table. The table is called NCRLog.
What would be the VBA code to find the last cell in Column A with data and apply the conditional formatting for only that row (from column A to Column J)?
I think it would start something like: Range("NCRLog").Cells(1, 1).End(xlDown)
But I really don't know what to do after.
Thank you
Carla
What would be the VBA code to find the last cell in Column A with data and apply the conditional formatting for only that row (from column A to Column J)?
I think it would start something like: Range("NCRLog").Cells(1, 1).End(xlDown)
But I really don't know what to do after.
Thank you
Carla