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
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'
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,
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
