Can this be scripted !

[Bob Vance]

-- Can this be scripted into a Macro>After active cell>
go down 16 cells, then go down the column to the next empty cell and
enter (Date)
..Offset(0, 1).Value = "PAYMENT RECEIVED"

So A has the date and B has payment received

Thanks in advance.........Bob Vance

 

[Bob Phillips]

Bob, I answered this in the other group.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob]

thanx but it is taking out my last cell with data in it