Macro to Copy Data on to several Sheets

[Howardc1001]

I have tried to write code to copy data on cell A1 on sheet "Data import" and paste as follows n sheets below:

1) paste on A1 on sheets Balance Sheet", "Balance Sheet Final Result" ,"Statement of Financial Position", "Stat of Comprehensive Income"
2) Paste in Cells E1 on sheets "Statement of Changes in Equity", "Cash Flow Statement"

Please Login or Register  to view this content.

I get a run time error "Object doe'snt support this propery or Method"


It would be appreciated if soeone could kindly assist me

[Marc L]

A VBA demonstration as a beginner starter :

    With ['Data Import'!A1] 
        ['Balance Sheet'!A1] = .Value 
        ['Balance Sheet Final Result'!A1] = .Value 
' and so on ... ' 
    End With  

[jindon]

1) You are missing one sheet, so grouping sheets will end by the runtime error,

Please Login or Register  to view this content.

2) Use of Select Case statement without error.

Please Login or Register  to view this content.

[mjr veverka]

... or ...

Please Login or Register  to view this content.

[Howardc1001]

Hi Guys

Many thanks for the help, much appreciated