I am trying to use a VBA from one workbook to another. When i run my vba it looks like my rngcell is = to nothing i need it to be the BU_Range from the BU INFO sheet.
Can somone help me with this. THe GXA is a global add on to Excel and should be ignored.
Dim rngCell As Range
For Each rngCell In Range("BU_RANGE")
Range("SRF-13 Branch Income Statement Act+Bud.xlsx]Options'!$B$4
") = rngCell '// change to your input cell //
' Add this macro to the active workbook to call Spreadsheet Server's clear cache and recalc.
'To the active workbook to call Distribution Manager's Distribute function.
'Distributes open file to location specified in (Options) sheet