Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have the following line of code
I'd be grateful for an amendment to this so the Range("J" & Lr2).Value copied is in the format 0000 i.e. leading zeros for values less than 1000 e.g. instead of "Session 345. " it will be "Session 0345. "
Many thanks!
I have the following line of code
VBA Code:
Sheets("Indoor Bike").Range("J" & Lr2).Value = "Session " & Sheets("Indoor Bike").Range("E5") & ". "
Many thanks!