Returning Row Number

**Bubba_OH** · 02-26-2011, 10:15 AM

I need vb to return the row number for the row containing my macro. For example, row 10 would return a 10, row 14 would return 14. All I can find is how to return the active row.

I do not want the active row.

This has got to be simple, but I can not find anything except the active row.

This is the foundation of something much bigger, but I can not even take the 1st step w/o this simple solution.

**Andy Pope** · 02-26-2011, 10:17 AM

What do you actually mean by,
"row number for the row containing my macro".

Surely your macro is in a code module rather than in a worksheet.

**Bubba_OH** · 02-26-2011, 10:48 AM

Yes, my code is in a module. I am new to Excel coding/terms, but not to coding in general.

If I make a function called MyFunction(), and I put it in cell C13 ( =MyFunction() ), I need the vb code to determine that it is row 13.

Again, this is just the starting point. Based on the solution I need, I will use offsets to reverse search through prior cells to make decisions.

**Andy Pope** · 02-26-2011, 10:55 AM

Please Login or Register  to view this content.

It depends on exactly what you are intending to do but you do know that udf (User Defined Functions) are limited in there interaction with the worksheet and objects.

**Bubba_OH** · 02-26-2011, 11:03 AM

Please Login or Register  to view this content.

Appears to be what I needed. I think I am good to go. Now I need to do things based on that as a starting point.

Thanks!

**royUK** · 02-26-2011, 11:35 AM

If you put in C13

=Row()

The value will be 13. So why do you need MyFunction?

How do you expect the rest of your code to use that information?

**Bubba_OH** · 02-26-2011, 06:49 PM

My worksheet has data in a parent, child, grandchild relationship. This is not something that should normally be done in Excel, but for my purposes, it is what I want. I need to make different calculation depending on where the data is in that relationship.

Maybe this is not the best way to do this, but based on how the data is entered, this should work well. My data is limited, so it will not get out of control.