| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a row using VBA
I would like to perform the following functions:
- copy the formulae in cells C100 to AA100 - paste the formulae above into cells Cxxx to AAxxx where "xxx" represents the row number associated with the value in Cell C105 (in other words if cell C105 reflects the value "75", the values would be pasted in cell C75 to AA75 - COPY and PASTE VALUES of cells C [75 - 1] or C&$ to AA74 (i.e. the value of Cell 105 LESS 1 or in other words, the one row up from the row indicated by cell 105) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| A visual basic value copy BUG?? - accounting format has copy problem!! | Excel Programming | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy formulas from a contiguous range to a safe place and copy them back later | Excel Programming | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Threaded Mode
