Hi guys,
I've been using this code (called by a form to select department and month) where section of it is:
Note that Xlfsheet and Offset(0, colnum) are stated on a little table on separate worksheet. And to determine which worksheet [Xlfsheet] (currently there are 20 of them) and which column [Offset] to update, I call a form to select those - No prob there.
However, after this code, then the following procedure is called to copy and paste value to the same range as the formulas:
The problem is that every I make a change to add a new row on my workbook, I need to go back and change the code for the entering of the formulas and the code for pasting of values. Is there a way to shortened this?
Note that I cannot use named ranges as there are multiple worksheets that are updated one after the other and 12 (one for each month) different columns for each worksheet.
Thanks,
Ron
Bookmarks