Previous Topic Next Topic

Rang selection

Closed
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 -
Hello,
I want to check the value in individual cell within a selected range, and if any cell found blank I want to put some
value such as N/A for some cells, that should have string as value and -1 for some cell that should have numerical value. I want to create the Macro in 1 workbook and run it for other workbooks. How can I do it.
Could any one please give me a suggestion.

1 reply

Answer 1 / 1
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 156
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 .......
Ask a question