Copying a formula

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

I would like to have a macro that will:
1. Type in a formula where the cursor is
located.Example(=if(a1<>12,"YES","NO"))
2. Will copy this formula down
..
How far down we copy this formula will be based on how many inputs there are
in Col A- it will vary from day to day
In this example I have used Col A.
In real life I would like to have my formula in the col adjacent(to the
right ) or where the info is located.
In other words, if Col F contained the data, I would place the cursor in Col
G and invoke this Macro/VBA code
 
Ian

I finally got back to yesterday's posting with an answer.

(e-mail address removed)

Gord
 
Back
Top