Last used column

LastColumn = activesheet.Cells(1, activesheet.Columns.Count).End(xlToLeft).Column

This will find the last used column on row 1 of the current sheet. It will return the number rather than the column letter.

Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us
the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group