help writing formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Ryan Proudfit" <RyanProudfit@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 5 Apr 2005 07:49:03 -0700

The current formula residing in about 200 cells is

='Daily N '!AN13

I'm trying to write a macro that will change that formula to

=IF(OR(B9=6,B9=7),"",'Daily N '!AN13)

Here is my code

ActiveCell.Formula = "=IF(OR(B" & ActiveCell.Row & "=6,B" & ActiveCell.Row &
"=7),""," & strHoldFormula & ")"

My problem is

"=7),"","

Since quotes are used to identify the beginning and end of a text string
within a formula, how do you use quotes within a formula to tell Excel to
display nothing if a condition is true?

--
Ryan Proudfit
.

Prev by Date: Re: Muliple Userforms and multiple Stacks
Next by Date: Re: Need HELP with QueryTable, ADO, EXCEL and EXCEL'S Formulas
Previous by thread: Solver in Visual Basic
Next by thread: Re: Excel vba code disappears when saved workbook is re opened
Index(es):
- Date
- Thread

Relevant Pages

summary of data from several workbooks in another
... i use a template for quotes to customers. ... through another macro) and date (these are 2 cells in the file) is used as ... file (which are range totals in the worksheet) and duplicate these cells' ...
(microsoft.public.excel.misc)
Re: summary of data from several workbooks in another
... i use a template for quotes to customers. ... through another macro) and date (these are 2 cells in the file) is used as ... file (which are range totals in the worksheet) and duplicate these cells' ...
(microsoft.public.excel.misc)
Re: summary of data from several workbooks in another
... i use a template for quotes to customers. ... a macro was created to save this file everytime as a new file where the quote number and date (these are 2 cells in the file) is used as the file name. ... what i need to do is to pick data from 11 cells in every new file (which are range totals in the worksheet) and duplicate these cells' ...
(microsoft.public.excel.misc)
inserting quotation marks
... I want to insert quotes in front of text in 1280 cells that already have ... Is there an easy way to do this with a macro. ... Prev by Date: ...
(microsoft.public.excel.misc)
Re: automate row insert to archive
... MSNStockQuote 'update quotes' button. ... from an add-in in a macro, ... Const sheetNameDB As String = "Database" ...
(microsoft.public.excel.worksheet.functions)