Formula "might slightly" change in Macro - how do I account for it?

[Graham Pall]

Hello all. Complete VBA noob here, and new to putting together macros for Excel, although many years ago I used to write DOS based macros!!

I am near the end of quite a large macro that is so far working ok. Just a little stumped as to how I go about this bit......

Column A has order numbers in it. The order number will only appear once for each assembly. If that assembly is made out of several different parts, then there will be a blank in Column A until the next order number appears for the next assembly.

So A2 could have an entry, and A3-6 will be blank. Then the next order number will be on A7. Normally I select blanks, and then enter "=A2" in A3, then just copy and paste the formula all the way down the column, and then unfilter, and all the blanks are filled in.

However, on the odd occasion, the first cell for the Formula entry could be A3/4/5 etc. Is there any way of saying to excel "whatever the cell number before is" make the formula =<prev number cell> ?

I hope that's reasonably clear lol.....

[ragulduy]

Try something like:

Please Login or Register  to view this content.

[Graham Pall]

Thanks ragulduy!

Seems Excel had already done it when I looked in the editor afterwards.

Will be handy to remember though.