Macro and formula
Closed
hephzibah
-
Jul 26, 2010 at 06:47 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 26, 2010 at 07:57 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 26, 2010 at 07:57 AM
Related:
- Macro and formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Run macro when cell value changes - Guide
- Run macro when cell value changes by formula ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 26, 2010 at 07:57 AM
Jul 26, 2010 at 07:57 AM
I am not too sure what you are trying to do and even why. Any how it seem thats you what you need to know is what row you are on before you run the macro
So first locate the row on which you are.
Selection.Row should give you the first row select
Selection.Rows.Count will give you the number of rows that you have select
in you formula you can have some thing like
Cells(myRow, "G").formula ="=Sum(D" & myRow & " + F" & myRow & " - " & myRow & ")"
Myrow is the row that was selected and you have already found out
So first locate the row on which you are.
Selection.Row should give you the first row select
Selection.Rows.Count will give you the number of rows that you have select
in you formula you can have some thing like
Cells(myRow, "G").formula ="=Sum(D" & myRow & " + F" & myRow & " - " & myRow & ")"
Myrow is the row that was selected and you have already found out