VBA Code to Auto Fill Down till Next Filled Cell & reapply the code with new value

Hi, Ram,

maybe this line of code works like expected:

Please Login or Register  to view this content.

As Column B has more values beyond row 27 that would return the number of the last row and would be needed to be limited to 27 in any case (you woukld need to break down the Autofill to pieces for each number).

Ciao,
Holger

Hi, Phil,

from what I read there are 2 limitations: only work until row 27 and have different values to fill up (not just one):

...so that it stops in previous cell & applies the code again till it reaches a cell before "-*-" which is at Cell B28...

Ciao,
Holger

Hi, Ram,

a sample for breaking the code up into a loop may look like this:

Please Login or Register  to view this content.

I need to add to the line of code from my first post that you would need to use

Please Login or Register  to view this content.

before the codeline as the command would raise an error if no empty cells are found and

Please Login or Register  to view this content.

after the line.

Ciao,
Holger

Hi, Phil,

The forum decided to post that post twice 27 minutes apart. Don't know why?

EF´s installinmg all new gimmicks instead of fixing old and too well known errors?

Performance of the Forum is bad this morning, and I doubt that the "Technical" Team involved by now will ever get the Forum to run without any flaws.

Ciao,
Holger