Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA help: Using user's selection to copy entire row
Greetings all,
I have two large spreadsheets, let's call them "Account" and "Toy Store". I want the user to run a macro that copies the entire row(s) of highlighted cells and places it at the bottom of a running total on the next sheet. For example: "Account" sheet: A B C D 1/1/07 Smith $342 $700 1/7/07 Jones $342 $855 2/1/07 Anders $342 $855 2/12/07 Johnson $342 $700 Say the user highlights the $855 cells (D2 and D3 in this example). I want the macro to take that selection, copy the entire row, and paste the row at the bottom of the "Toy Store" worksheet (ideally leaving room for a few rows of totals). How can I make the Selection property return the row number(s), and how can I make sure it pastes at the bottom of the other sheet? Thanks so much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot expand the selection to entire spreadsheet when sorting | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
copy worksheet multiple times base on user's input | Excel Worksheet Functions | |||
How to set the entire selection to a specific value without using VBA | Excel Programming | |||
VBA Code Interferring with User's Copy Action | Excel Programming |