| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple copy column works but ERROR!
I use the following to 1) delete content in sheet 1 a:b
2) copy 2 columns (a:b) that are filtered - sheet2 Sub Macro1() Sheets("Sheet1").Columns("A:B").ClearContents Sheets("Sheet3").Activate ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisib le).Copy _ Destination:=Sheet1.Range("A1") End Sub I need this to paste in sheet1 - a1. It works but I get an error 1044. Is my syntex correct? Am I able to ignore error? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Macro Works on PC But Not Mac--Help! | Excel Discussion (Misc queries) | |||
| Criteria error but still works | Excel Worksheet Functions | |||
| Error Handling works only once | Excel Discussion (Misc queries) | |||
| Works if I copy F Col to A Col | Excel Worksheet Functions | |||
| Simple Macro, works in Excel 2002, 2003 but won't work in 2000 | Excel Programming | |||
Threaded Mode
