Skip to Content
0
Former Member
May 13, 2008 at 12:03 AM

Maco with cell fixing

26 Views

Hi all,

I need to write a macro as follows,

If KF1 is not fixed

Then copy KF2 to KF1

I wrote a macro as below,

IF

Condition

---KF1(value)

---<>

---KF1(Fixed value)

KF1=

---KF2

ENDIF

This works as long as KF1 value is other than blank and ZERO.

Can someone suggest a way out pl

Thanks in advance