1. Z

    VBA Using variable workbook and worksheet in a different sub

    Here is the code I have right now Public ReportFile as Workbook Public ReportWorksheet as Worksheet Sub VBA_Project() Define_File Define_Tab Data_Cleanup End Sub Sub Define_File() Dim ReportFilePath As Variant ReportFilePath = Application.GetOpenFilename(filefilter:="excel...

Some videos you may like

This Week's Hot Topics