Rang selection
Closed
Mahfuz
-
Jul 1, 2009 at 10:43 PM
mubashir aziz
mubashir aziz
- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010
Related:
- Rang selection
- Range(selection selection.end(xldown)).select - 1 - Forum - Office Software
- Selection.autofill destination:=range ✓ - Forum - Excel
- Excel - A macro to copy/paste a selected range - How-To - Excel
- Excel - Selectively Transfer Data to Pre-defined Range - How-To - Excel
- Creating pdf from selected cell range ✓ - Forum - Excel
1 reply
mubashir aziz
Jul 2, 2009 at 01:40 AM
- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010
Jul 2, 2009 at 01:40 AM
I am not an expert in Macro but can give you suggestion by using work sheet function, if you like .....
Suppose you have data in A1 now in B1 you can write below formula
=IF(ISBLANK(A1),"N/A",IF(ISNUMBER(A1),-1,IF(ISTEXT(A1),A1,"")))
After this you can drag it down and by using paste special just paste values in column A .......
Suppose you have data in A1 now in B1 you can write below formula
=IF(ISBLANK(A1),"N/A",IF(ISNUMBER(A1),-1,IF(ISTEXT(A1),A1,"")))
After this you can drag it down and by using paste special just paste values in column A .......