PDA

View Full Version : Copy data fields macro



keilah
09-04-2007, 04:42 AM
Hi

Need a macro that will copy data from a fixed range exact match from the same work book, from one work sheet to another.......irresecptive if the work sheet is hidden or not......

copy from work sheet - original data-

paste into work sheet accounts-

data range: D7:CZ200

thanks

keilah
09-04-2007, 07:11 AM
Ignore this question i have solved the problem.....

thanks

lucas
09-04-2007, 07:18 AM
Worksheets("accounts").Range("D7:CZ200").Value = Worksheets("original data").Range("D7:CZ200").Value