View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DataDude DataDude is offline
external usenet poster
 
Posts: 2
Default 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