ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with largest

Sun
Dec 3
2006

How to find the largest non-empty row of an Excel column with VBA code?


Answer

I guess you mean the largest value in a range of cells, right?

If so, then you can do one of the following:
1- Use another cell with the function of
=Max( B:B)
then call that cell using the object [Range]
MaximumValue = Range("A1").Value

2- Use the powerfull feature WorksheetFunction that will enables you to use some of Excel built-in functions in VBA, example:
MaximumValue = WorksheetFunction.Max( "Sheet1$B:$B")

Or...
You may want to find which row have the largest no of non-empty cells.
If so, then you will need som fomrula combination, I will need you to mail me here if you are looking for that in particular.
I also will need you to answer some questions like (Do these rows are one after one? means they don't have empty rows in between?)



mail me here for any further info

Enjoy my profile, I am the VBAXLMan

Sunday 12/3/2006 3:19:22 AM

Tags

History