Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying cells
Hi there, I've created a macro at the top of a page that inserts two rows and
copys some text from above, to create another 'entry' but ive also done this further down but after ive run the top one it then puts the bottom one out of sync, is there any way of making a macro relative to a certain cell or relative to the button that runs it? or any solution will do... i just need to be able to replicate bits of text to create room for more entries at different stage down the page, help much appreciatedĀ¬! thanks Will |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying cells
If you recorded a macro you probably got references hard wired to specific
cell addresses. Typically you want utility macros to run off of the active cell or selection, so you'd replace specific cell references with ActiveCell or Selection. Can't say any more without your actual code. -- Jim "bilbo+" wrote in message ... Hi there, I've created a macro at the top of a page that inserts two rows and copys some text from above, to create another 'entry' but ive also done this further down but after ive run the top one it then puts the bottom one out of sync, is there any way of making a macro relative to a certain cell or relative to the button that runs it? or any solution will do... i just need to be able to replicate bits of text to create room for more entries at different stage down the page, help much appreciated¬! thanks Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Cells | Excel Discussion (Misc queries) | |||
Copying cells | New Users to Excel | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
copying cells | Excel Discussion (Misc queries) |