I hope I'm asking this clear enough without having to create a mini-sheet to reference.
This is an example of the type of formula in my spreadsheet that I don't know or can't find out how to automatically change and reference a different sheet using vba.
='06'!$D82 & "_" & '06'!$G82
Here's what creates the need for this. I have a Macro that selects the current 'last' sheet tab '06' using Sheets(Sheets.Count).Select .
When that macro is through running, '07' becomes the newest 'last' sheet in the file.
Is there vba code that I can use to change the '06'! in the formula to '07'! without having to manually type it into the cell each time I use the macro to add an extra sheet? The place I need to paste or place the new formula referencing tab '07'! is in a column directly next to the formula referencing tab '06'!
This is an example of the type of formula in my spreadsheet that I don't know or can't find out how to automatically change and reference a different sheet using vba.
='06'!$D82 & "_" & '06'!$G82
Here's what creates the need for this. I have a Macro that selects the current 'last' sheet tab '06' using Sheets(Sheets.Count).Select .
When that macro is through running, '07' becomes the newest 'last' sheet in the file.
Is there vba code that I can use to change the '06'! in the formula to '07'! without having to manually type it into the cell each time I use the macro to add an extra sheet? The place I need to paste or place the new formula referencing tab '07'! is in a column directly next to the formula referencing tab '06'!