Macro to complete table of data

Hi,

I am trying to write a macro that enters the value 0 (zero) in the cells across a row from Column F to the last used column in the row above. The last used column will move from month to month, so I need this to be able to capture this variable.

Can anyone assist me in doing this?

To simplify, rows 1 to 10 have data from Column A to M, but there is data needing to be added down to row 15. I am needing to enter zeros from column F to (in this case) M for rows 11 to 15. How can I write a macro that populates the cells from F11:M15 with zeros, but can change the row and column as the data is altered?

Thanks in advance for your help.
Robbie

Please Login or Register  to view this content.

I hoped you were able to find out yourself, given he frist step I gave.

Look into VBEditor's help files. Look for 'resize'.