Copy Highlighted Cell With Loop

Microsoft Office excel 2007
August 24, 2010 at 23:08:36
Specs: Windows XP
Hi All
i have this problem.I need a macro to do a loop that
at every worksheet that starts with "Data_" ,
it will copy the highlight cell .Interior.ColorIndex = 6 from "ACTUAL DATA" worksheet and paste in each of the worksheet at cell E33.Any idea how should i be doing this?

See More: Copy Highlighted Cell With Loop

Report •

August 24, 2010 at 23:15:38
i manage to do a bit of code but obviously i am still quite far from my solution

Dim ws As Worksheet
Dim rCopy As Range
Dim rDest As Range

Set rDest = ActiveWorkbook.Worksheets("ACTUAL DATA").Interior.ColorIndex = 6.Copy
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> "Data_" Then
End If
Next ws

Report •
Related Solutions

Ask Question