bopo
10-24-2008, 02:59 PM
Hi ppl
Basically I have quite a large spreadsheet with a couple of thosands rows (or records :)), anyway not every cell contains data, I need a loop which will loop through each cell from say A1 to V4500 and insert "N/A" if the cell is blank, but im not quite sure on the coding as I havent touched vba for a while.
Help appreciated.
Basically I have quite a large spreadsheet with a couple of thosands rows (or records :)), anyway not every cell contains data, I need a loop which will loop through each cell from say A1 to V4500 and insert "N/A" if the cell is blank, but im not quite sure on the coding as I havent touched vba for a while.
Help appreciated.