Delete certain cells of active row
Solved/Closed
Related:
- Delete certain cells of active row
- How to delete whatsapp contact not in address book - Guide
- Delete fake facebook account within 24 hours ✓ - Facebook Forum
- How to delete a row in word - Guide
- How to delete whatsapp account without phone - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
4 replies
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Sep 25, 2009 at 08:32 PM
Sep 25, 2009 at 08:32 PM
try
cells(r,5) and cells(r,7)
cells(r,5) and cells(r,7)
How do you declare r ? Variant? integer? range?
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 5, 2010 at 02:43 PM
Mar 5, 2010 at 02:43 PM
Long would be the safest. It is being used to handle row numbers.
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 5, 2010 at 09:53 PM
Mar 5, 2010 at 09:53 PM
[quote]
How do you declare r ? Variant? integer? range?[/quote]
something like this
dim r as range, j as integer, k as long,m(leave it blank then it is variant)
How do you declare r ? Variant? integer? range?[/quote]
something like this
dim r as range, j as integer, k as long,m(leave it blank then it is variant)
Sep 28, 2009 at 07:56 AM