Macro Range
Solved/Closed
Jim Clanton
Posts
3
Registration date
Thursday August 8, 2013
Status
Member
Last seen
August 9, 2013
-
Aug 8, 2013 at 06:03 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 10, 2013 at 12:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 10, 2013 at 12:14 AM
Related:
- Macro Range
- Spell number in excel without macro - Guide
- Apple airtag range - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Selection.autofill destination:=range ✓ - Excel Forum
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 9, 2013 at 06:03 AM
Aug 9, 2013 at 06:03 AM
i wonder can you not do this in this code
For i = r To 2 Step -1
instead of 2 can you not type some other number 7 or l9 or 12
For i = r To 2 Step -1
instead of 2 can you not type some other number 7 or l9 or 12
Jim Clanton
Posts
3
Registration date
Thursday August 8, 2013
Status
Member
Last seen
August 9, 2013
Aug 9, 2013 at 07:39 AM
Aug 9, 2013 at 07:39 AM
Thanks vankat. That worked perfectly. If I knew what I was doing I would have probably known that.
Thanks again,
Jim
Thanks again,
Jim
Jim Clanton
Posts
3
Registration date
Thursday August 8, 2013
Status
Member
Last seen
August 9, 2013
Aug 9, 2013 at 10:16 AM
Aug 9, 2013 at 10:16 AM
venkat
As I said, your solution worked great. The only problem is that the person I was doing this for wants the column and stop row to be those of the selected cell. I'm sure you know that you never get the whole story in the beginning.
Thanks,
Jim
As I said, your solution worked great. The only problem is that the person I was doing this for wants the column and stop row to be those of the selected cell. I'm sure you know that you never get the whole story in the beginning.
Thanks,
Jim
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 10, 2013 at 12:14 AM
Aug 10, 2013 at 12:14 AM
I seem to have answered this perhaps to a private message . please see that.