| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste - Last Row
I am a new to most of this but have done ok with google so far. I have a problem doing a copy and paste , trying to paste into the first blank row of a workbook. Here is what I am trying to use right now
..Columns("A:F").AutoFilter Field:=6, Criteria1:="Brand ..Columns("A:F").SpecialCells(xlCellTypeVisible).C opy Destination:= Windows("AllBrands").ActivateSheets("Sheet1").Rang e("A" & Rows.Count).End(xlUp).Offset(1 I get this error message - and I am not sure what it mean "Object Doesn't Support This Property Or Method It is pasting from one workbook to another - in case that is importan I would appreciate any advise I can get on this - I am really not sure what is wrong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Threaded Mode
