Re: $$Excel-Macros$$ "Ring-Fence" macro's copy/paste, so can copy/paste without interference outside the macro

2011-05-01 Thread tomfabtas...@hotmail.com
aste, so can > copy/paste > without interference outside the macro > > Hi Tom, > Problem is, when you use copy/paste in a macro, it uses the same clip board as > any other application that's running. The solution is probably to eliminate > copy/paste from your macro. It'

$$Excel-Macros$$ "Ring-Fence" macro's copy/paste, so can copy/paste without interference outside the macro

2011-04-14 Thread tomfabtas...@hotmail.com
Hi, I run an excel macro on a loop (Excel 2007), which runs for most of the day and includes copy/paste code. While this macro is running, in another instance of excel I need to copy and paste (manually, not using a macro). Sometimes when I manually copy/paste, I get the paste from the macro. So, t

$$Excel-Macros$$ Colour pallette changed when sheet imported.

2010-07-22 Thread tomfabtas...@hotmail.com
Hi, I copied a sheet from one excel file to another (right clicking on sheet name and ticking "Copy" box). The effect was to change the colour pallette in the destination sheet to be the same as the colour pallette in the original sheet. How can I get the old colour pallette back ? I tried copyin

$$Excel-Macros$$ MATCH question

2010-04-08 Thread tomfabtas...@hotmail.com
Hi, In an excel worksheet, I have the below formulas in three different cells. Is there a way to replace the SR_P1!$1:$1, SR_P2!$1:$1, SR_P3! $1:$1 parts of the function by referencing another cell (maybe using the address function, or similar) ? MATCH($A15&D$47, SR_P1!$1:$1, 0) MATCH($A15&D$47,