try to use a worksheet object
I must be missing a concept here
Why does this not work
Dim FY As Strin
Dim chartsheet as workshee
Set ChartSheet = Sheets("PORChart"
FY = ChartSheet.txtF
When this does work
Dim FY As Strin
FY = Sheets("PORChart").txtF
Call code is executed form a separate code module
Any explanation would be great
Thank
|