I have a spreadsheet which imports a CSV file. I have setup a macro to import and format the CSV correctly. However what I need is to be able to find the first blank cell at the bottom of each column of data and total the entire column. If I use the macro recorder it gives me a fixed range i.e A2:A256. Unfortunately the CSV file differs in size every month and the VBA code should cope with this.
TIA
Rex.
TIA
Rex.