| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run time error 1004
Glad you got it working!
cinvic wrote: What an absolute macro guru!!! IT WORKED!!! I jumped up and down so much it made my dog wail. THANK YOU. A drink awaits you in IL. "cinvic" wrote: It was a fluke. I still can't get the formulas to paste after running a macro with an advanced filter. The advanced filter's action is xlFilterCopy. I tried putting the paste function after the Unique:=False and I still get the time error. I am using: rng.PasteSpecial Format:=xlPasteFormulas "Range" is the master file that is to be broken out into individual worksheets. Else Set wsNew = Sheets.Add wsNew.Move after:=Worksheets(Worksheets.Count) wsNew.Name = c.Value rng.AdvancedFilter action:=xlFilterCopy, _ CriteriaRange:=Sheets("Macro for wb").Range("L1:L2"), _ CopyToRange:=wsNew.Range("A1"), _ Unique:=False rng.PasteSpecial action:=xlPasteFormulas End If Frustrated!!! -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| time differences in a column | Excel Worksheet Functions | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
