Copying a formula "literally"

Hi. Any copy operation puts Excel into CutCopyMode, and will adjust the
references.
As one alternative, see if this macro will work for you.

Sub Demo()
Columns(2).Formula = Columns(1).Formula
End Sub

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"ArthurJ" wrote in message
...
Say I have the following relative reference formulas in Col A:
+D1
+D2
+D3

I want exactly the same formulas in Col B:
+D1
+D2
+D3

I can change the formulas in Col A to absolute reference, copy/paste them,
and then change all formulas back to relative. Along similar lines I could
add an apostrophe in front of each formula before copying it, thereby
changing it to text, then removing it after the copy/paste.

But these methods are manual and cell by cell.

Is there a quicker way to do this, short of writing VBA code?

Art