| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL macro that will vary when copied
I want a "macro button" that acts on one row to be able to be copied in many
other rows(1200), without having to write a new macro for each row. (to Copy-Paste it and have it act the same as an EXCEL formula, changing the relative addresses automatically). In paricular, all the button does is take the cursor "Home" in the same row (leftmost column), insert the digit "1" in that cell and move one column to the right. Any ideas? (I don't speak "Basic"....) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a macro that will select a range that can vary in | Excel Discussion (Misc queries) | |||
| In excel, how do I vary a cell over a data range & see its effect? | Charts and Charting in Excel | |||
| vary row colors in excel? | Excel Discussion (Misc queries) | |||
| excel should let you vary error bars for individual points | Charts and Charting in Excel | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
Threaded Mode
