Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some code that operates in a loop that should filter a table for a
particular value, copy the visible cells and then paste them at the bottom of the table. The filtering and copying works, but having trouble with pasting to the bottom of the table. Here is the code snipet, any help would be greatly appreciated. With Workbooks("Tables").Sheets("Top8").ListObjects("tb lTop8Issue") .Range.AutoFilter Field:=7 .Range.AutoFilter Field:=1 .Range.AutoFilter Field:=7, Criteria1:=(iCW - 1) .Range.AutoFilter Field:=1, Criteria1:=iLoop .DataBodyRange.SpecialCells(xlCellTypeVisible).Cop y .Range.AutoFilter Field:=1 .Range.AutoFilter Field:=7 Error - .Range("tblTop8Issue[[#Headers],[Issue_Num]]").End(xlDown).Select here ActiveCell.Offset(1, 0).Select ActiveSheet.Paste ActiveCell.Offset(0, 1).Value = Top8CpaEntryForm.txtWeek End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy & paste table | Excel Discussion (Misc queries) | |||
copy paste only value with VBA from pivot table | Excel Programming | |||
how do I copy and paste table from netbank? | Excel Discussion (Misc queries) | |||
Q: copy/paste table from Word | Excel Discussion (Misc queries) | |||
Pivot Table Copy Paste | Excel Programming |