Declaring Variables of Active sheet and another opened through FileDialog.

[julhs]

This previously posted under “FileDialogPicker” tread title, not marked that as solved due to my inability to Declare the Variables
of the two Workbooks in question and complete the code to test it. Could someone be so kind as to have a look the Declared or
not so Declared Variables for me and put me right? Then I can mark both as solved.

The more I have read and studied examples the more confused I have become!!!

Many thanks

julhs


http://www.excelforum.com/excel-prog...html?p=3142183

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

You may find this helpful:
10 ways to reference Excel workbooks and sheets using VBA

[julhs]

AlpaFrog

I think my principle mistake was I was declaring the variables for the source and destination sheets by the wrong names
outside of the sub routine “Paste to Sheet”. Although not evident from the uploaded example as that was the edited version.

I WILL read the links you sent and I WILL endeavour to get my head around how and where to Declare Variables.

Many thanks for your help

julhs