Search results for query: *

I’ve created a 2-page report going to 3000 clients (7000 pages ). Page 1 of the report contains typical text and numeric data and page 2 has an individualized map (based on 3000 .jpg external files-each file about .8MB). The problem is that after approximately 200 pages the map image no longer...

Gavin, I overlooked the ignore blank checkbox. Once I removed the check the data validation worked as expected. Thanks for your help.

Gavin, I tried =AND(B2>=0,B2<=15,ISBLANK(C2)) and still do not get an error message when I enter a value such as 25 in cell B2 and C2 is blank. I also tried =AND(B2>=0,B2<=15,LEN(C2)=0) and again do not get an error message when I enter a value such as 25 in cell B2 and C2 is blank. any...

I am trying to apply a custom validation criteria formula which allows a value in column B between 0 and 15 as long as there is no value in the corresponding cell in column C In the custom formula I have =AND(B2>=0,B2<=15,C2=””) when I enter the value 25 in B2 and C2 is empty the value is...

Tony, the files weren't in the same folder when the hyperlink was originally created. When the hyperlink was created with both files in the same folder the hyperlink opens the second workbook. Thanks for your help, Roy

I'm trying to create a hyperlink in one Workbook to open a second workbook. As part of the code i have the follwoing lines: strFileName = "SmithJobDesc.xls" Activesheet.Hyperlink.Add Anchor:=Selection,Address=strFileName,TestToDisplay="Position" When the code is run a hyperlink is...