Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help!
I am trying to do a number of different things in a single macro and can't seem to make it work. 1) I need to copy a data range (that vaies in length and width) that begins in cell B20 in Sheet 1. 2) The copied data then needs to be pasted (as values) into Sheet 2 into the first available row in column A. ...by first available row, I mean the the first row that does not contain data. 3) The original copied data (from #1) needs to be cleared, but the formulas must remain. Any assitance would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
Copy - Paste Special | Excel Discussion (Misc queries) | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |