Variables to multiple cells on multiple sheets

[BoBoCoDeR]

I am a novice VBA programmer.

So far I have successfully created macros that move data from cell to variable and from variable to cell on a sheet.
I did this by doing something like this:

Please Login or Register  to view this content.

Now I need to move data from sheet1 to sheets 2-9
All the data I need to move is saved to variables.

If I ran the code with the select line uncommented I get an Unable to get the selct property of the range class error
so I commented it out

Here is where the insanity part comes in.
Going through the code it works perfectly for the first variable I am assigning to a sheet2
The second variable I try to assign to a cell on sheet3 and I get an error object missing.
Here is the code:

Please Login or Register  to view this content.

Here is a Screen Shot:
code.gif

Please help... I'd have this all done by now if I wasn't getting this error!
Thank you so much for your time in helping me in anyway possible.

I am a novice VBA programmer.

So far I have successfully created macros that move data from cell to variable and from variable to cell on a sheet.
I did this by doing something like this:

Please Login or Register  to view this content.

Now I need to move data from sheet1 to sheets 2-9
All the data I need to move is saved to variables.

If I ran the code with the select line uncommented I get an Unable to get the selct property of the range class error
so I commented it out

Here is where the insanity part comes in.
Going through the code it works perfectly for the first variable I am assigning to a sheet2
The second variable I try to assign to a cell on sheet3 and I get an error object missing.
Here is the code:

Please Login or Register  to view this content.

Here is a Screen Shot:
code.gif

Please help... I'd have this all done by now if I wasn't getting this error!
Thank you so much for your time in helping me in anyway possible.

[davesexcel]

You don't have to select the sheets and range to place a value

Please Login or Register  to view this content.

You can also Loop through the sheets

Please Login or Register  to view this content.