Rang selection

Closed

Mahfuz - Jul 1, 2009 at 10:43 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:40 AM

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.

Rang selection
Screenshot excel selection - Guide
Make selection photoshop - Guide
Network selection iphone - Guide
Virtualbox temporary boot device selection - Guide
Selection is locked - Office Software Forum

1 response

Answer 1 / 1

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
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 .......

Similar discussions

how to make an invert-er

video disappear from laptop to tv in between.

Unlock selection mode

choose the game application for "call of duty 4

Change colour of range of cells based upon text from a drop down menu in another

Similar discussions

Subscribe To Our Newsletter!