Excel: Get number of columns from a "Current Region"

[Privacy]

Hi,

 

On Excel, how can I get the total number of columns only on a "Current Region"?

I want to give an active cell, get the $oRange of Current Region and get the number of columns in that range.

 

PD: I have read the Wiki but I can't get any result.

 

Thank u!

[water]

$iColumnCount = $oWorkBook.Activesheet.Range("B4").CurrentRegion.Columns.Count

Example for Cell "B4".

[Privacy]

Excellent, It works!

Than you for your fast help and greats UDFs.

[water]