Search results for query: *

I don't know if this is much help but could I suggest that you change your greater than and less than conditions to be 'betweens'? For instance: condition 1) if cell < 25 then yellow condition 2) if cell > 700 then red condition 3) if cell between 25 and 700 then blue could be changed to...

The formula is referring to the sheet and not the named range. I've seen people use VBA to assign a name to the range and then adjust their formula to refer to the range. i.e. GeneralLedger!$B$9:$B$4800 named as 'ABC', GeneralLedger!$D$9:$D$4800 named as 'DEF', GeneralLedger!$Q$9:$Q$4800 as...

If your formulas are referring to the named range then they should be updating as well. I've seen instances where a range is named identically to the sheet it resides in (i.e. sheet name &quot;HourlyData&quot; and the range of data on the sheet is named &quot;HourlyData&quot;). It might help...

rpg121 - Try this. First record a macro (Macro1). Enter the VLOOKUP formula you are wanting to code into a cell in the spreadsheet and then stop recording. Edit Macro1 and voila! there's your VBA code. Hope this helps!

Muzzy - Make sure to assign a variable to the answer of the Msgbox. ans = MsgBox &quot;Are You Sure You Want To Submit The Quarterly Figures?&quot;, vbOKCancel, &quot;Are You Sure?&quot; If ans = vbCancel Then Exit Sub Else DoCmd.Hourglass True stDocName =...

Hi there. I recently had this problem myself. I found this to work: Workbooks.Open Filename:= abc.xls If ActiveWorkbook.ReadOnly = True Hope this helps. Cheers KathyD