Excel Macros

[eduardo veiga]

What is the problem with the macro : below

Sub M()
 
C = Worksheets("SHEET1").Range("B5")
C = ActiveCell
My_row = ActiveCell.Row
 
End Sub

I would like that excel give me back the information of My_Row=5, because that is the row of the Range B5. How can I do this?

:confused:

[michelle]

Hello eduardo,

Try this:

C = Worksheets("SHEET1").Range("B5").Select
C = ActiveCell
My_row = ActiveCell.Row

Nice regards,
Michelle.

[dave ellis]

: below


I would like that excel give me back the information of My_Row=5, because that is the row of the Range B5. How can I do this?

:confused:

Sub M()
 
C = Worksheets(1).Range("B5").Address
My_Row = Range(C).Row
 
MsgBox C       ' you may remove these two lines when finished testing
MsgBox My_Row  ' you may remove these two lines when finished testing
 
Range(C).Offset(0, 0).Value = C & ", " & My_Row 
' modify the (0, 0) to read (0, 1) for example, and you can see the result being placed to the right of the C range instead of within it
 
End Sub
 
 

you can now modify this in your choice of ways, to arrive more closely at the result you wanted.