Refer to .Row or .Column

[drom]

Hi and thanks in advance!

I am using the following line of code:

For X = ActiveCell.Row To 1 Step -1
For X = ActiveCell.Column To 1 Step -1

and inside the For ... Next, many lines of code, but the only thin I change inside the For Next is when I refer to

.EntireRow.Hidden Then
.EntireColumn.Hidden Then
Activecell.row ...
Activecell.column ...

Is there any way of doing:

Call MyMacro (wColumnOrRow as string, wEntireColumnOrRow as string)

and then use:

• For X = ActiveCell(wColOrRow) To 1 Step -1

I do not want to use inside the for Next kind of:
'if then else
I am tryng to know if is possible to refer to .Column or .Row using a variable kind of:
debug.print Activecell(indirect(wColumnOrRow)) or ???

 

[RoryA]

Weird request (), but yes, you can use CallByName - for example:

callbyname(activecell, "Row", VbGet)