Count Merged Cells

[rsbuzatto]

Hello folks!

I have the following "table" in my sheet and I'm in trouble to find a way of a code for what I need...

Basically, my code must be able to identify my merged cells and, according to my product's name, fill my column 1. For example:

My first product is XXX and, for XXX I've defined the value 15, so this value (15) must be filled in the same rows that my XXX product are merged (same structure must happen to my second product and so on...).

PS: Those merged cells are variable, so, today I can merge 10 cells for first product and the rest of them for the second product... and tomorrow I can change thouse merged cells and so on...

However, I couldn't find a way to write this code (identifying my merged cells and fill my column according to it).

Is there any help from you guys?

Thanks in advance for any help and sorry if I'm not clear enough...


Cheers,

 

[rsbuzatto]

Anyone...? :|

 

[TKB]

Ill take a stab at it, but i need to know where the 15 is supposed to end up.

 

[rsbuzatto]

Ill take a stab at it, but i need to know where the 15 is supposed to end up.

It supposes to end up where the merged area of the product's name ends. That's why I'm in trouble with...

So... in this example, my 15 value must be written in the red area!

Yet, my value column will be variable according to my merged cell... if my merged cell is 4 rows, my value must be written in those 4 rows and so on...


Thanks dude... hope you understand better now...

 

[Warship]

maybe something like:

Sub test()
    Dim rngValue As Range
    Dim MergeRow As Long
    Set rngValue = ActiveCell
    MergeRow = Cells(rngValue.Row, 1).MergeArea.Rows.Count
    rngValue.Resize(MergeRow, 1).FillDown
End Sub

 

[rsbuzatto]

Warship, I couldn't apply your code here... :\

Anyone help, please?


Thanks a million!