Good day.
Please I want help to find the last column within a range (DS4:ED4)with vba. Thanks in advance
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Find last column using vba
0
Answers
0
Hi Sirwan and welcome to the Forum
If there is never data beyond column ED, then Don has a tutorial on this site for that; see: Find the Last Column with Data in Excel VBAand you can get the last column in row 4 (in bold below) using:
Cells(4, Columns.Count).End(xlToLeft)