Logo 
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.

  
Question Answered By: Agatha Miller   on Mar 04

data(i) is in a loop (sorry, i left a bunch of the code out), where
it loops through the array  and adds a sheet and renames it with the
value in the array. it then copies information from one worksheet,
and adds it to the worksheet  just added (named by the department in
the data array). there are 31 departments (these are accounted for
already), and the array has already been filled with the integer
number of the departments (e.g. 310). so the code looks more like
this:

for i = 1 to departments
Worksheets("Report - Acct Detail").Range("A1:Q8").Copy
Worksheets(Data(i)).Range("a1").PasteSpecial
next

also, the array is made up of all integers.

does that help?

Share: 

 

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.


Tagged: