Finding the column End and naming that

[gaby58]

Hello all,

I have macro set up which will name the last columns, however the last columns are not the same in different work sheets, how do i find the last column and rename that?.

Thanks

[rylo]

Hi

Try this

Please Login or Register  to view this content.

It will give you the last used column number.

rylo

[gaby58]

After finding the last column, could you please provide the code to name that column, I have to name 2 columns with Temp and Perm as headings. Thanks

[SOS]

Hi gaby58,

Following on from rylo's code the following sub dinfs the last column and names the next column "Temp" and the next column "Perm". That is assuming that you want row 1 to have values input.

Change the 1 in the line:

Cells(1, findit +1).Value

to whatever number corresponds to the row you want the heading to be in

Please Login or Register  to view this content.