Hi,
I have a sheet which is set up in a way where there are about 200 columns with many rows of data. The rows to use for the code is quite easy because I can just use some simple code for last row.
for example a simple part of it is below
My problem lies in the columns. Out of the ~200 columns only 20 (max) will ever be used in the spreadsheet but the 20 used varies from project to project. The columns which are used are displayed in row 4 ("n4:ho4") with a number and the columns which are not used have a "-".Please Login or Register to view this content.
How would you go about doing the above code so it only needs to use the 20 filled columns rather than the whole range? I'm a simple man who can't work this out! Any help would be appreciated. This would speed up my spreadsheet by about 10x.
Bookmarks