Hi Forum
Hope all is well. I recently came to the forum for some assistance with a Macro. I received a couple of responses however I was unable to make them work. As such I thought I would try again.
I have a macro that copies sheets from other workbooks into an equivalent sheet master book.
Sample
I have already created a workbook DB EOL in Supportability Resilience Report July 2017 V1.0.xlsx.
The problem I have is I am using a fixed Range Range("A1:T1551").Select, and the size of this worksheet changes every month.
What I would like to do is open DB EOL and get the range of the worksheet without hard coding the line in the macro.
Hope someone can help me out here, and as always many thanks for any help with this.
Regards
Rob
Hope all is well. I recently came to the forum for some assistance with a Macro. I received a couple of responses however I was unable to make them work. As such I thought I would try again.
I have a macro that copies sheets from other workbooks into an equivalent sheet master book.
Sample
Sheets("DB EOL").Select
Workbooks.Open ("C:\Resilience Reports\Development\Supportability\DB EOL.xlsx")
Windows("DB EOL.xlsx").Activate
Range("A1:T1551").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Supportability Resilience Report July 2017 V1.0.xlsx").Activate
ActiveSheet.Paste
In this example DB EOL is the target sheet and DB EOL is the source workbook. Workbooks.Open ("C:\Resilience Reports\Development\Supportability\DB EOL.xlsx")
Windows("DB EOL.xlsx").Activate
Range("A1:T1551").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Supportability Resilience Report July 2017 V1.0.xlsx").Activate
ActiveSheet.Paste
I have already created a workbook DB EOL in Supportability Resilience Report July 2017 V1.0.xlsx.
The problem I have is I am using a fixed Range Range("A1:T1551").Select, and the size of this worksheet changes every month.
What I would like to do is open DB EOL and get the range of the worksheet without hard coding the line in the macro.
Hope someone can help me out here, and as always many thanks for any help with this.
Regards
Rob