Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Magenta Ricci on Mar 04 In MS Office Category.

Problem copying/pasting with variable in worksheet name

Question Answered By: Sonya Flores on Mar 04

Replace
Worksheets(Data(i)).Range("a1").PasteSpecial

With
Worksheets(CStr(Data(i))).Range("a1").PasteSpecial

A string is expected instead of an integer. Hope this helps.

This Question has 5 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Problem copying/pasting with variable in worksheet name Or get search suggestion and latest updates.

Related Topics:

Activate a worksheet or workbook with a variable name
Problem with Length of the worksheet name
Need help coping images (gif pictures) from worksheet to worksheet
Need help coping images (gif pictures) from worksheet to worksheet
Excel data transfer automatically from master worksheet to other worksheets
saving a worksheet with the name read from a text file
how do I get the current worksheet name into a variabl
Protecting worksheet names
opening output files by naming it with the help of variables i and j
Error when using variable to name a range
making a spreadsheet cell name a global variable in the VBA project
retrieving file with variable (date) name
Dynamic Variable Name creation
what is instance variable and class variable.
What variables are in heap and what variables are in stack
multiplying two integer variables and assigning to a long variable
problem with variables
Non-static variables problem
move between worksheets
Run-Time Error '1004' (Copying worksheets)

Tagged:problem copyingpasting with variable in worksheet name

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us