Hey I need to write formula = Getcells(W:AF) so that it fills down the whole sheet but stops when column A no longer has data. I want the formula to be inserted into column AG. I also would like the formula =len(AG) in each cell down the whole page for each worksheet. Does anyone know if this is possible? I have experimented but no success :/
Bookmarks