My workbook holds a month template and sheets for each month. I work on modifications in the template ,but would then like to update all the monthly worksheets. I recorded a macro to show me how to start programming the vb sub, but get a runtime failure
'error 1004 Select method of range class failed'
when trying to select the column to copy,
The sub isPlease Login or Register to view this content.
This is run from a command button on a summary sheet. Could anyone tell me why this fails on selection of the column to copy? ThanksPlease Login or Register to view this content.
Bookmarks