Search results for query: *

Thankyou. Everything worked out. -Q

I am using a perl script for guestbook and am new to this. I have an output page that is generated by the perl script in which is an Acknowledgement and Thankyou page for signing the guest book. My question is how do I add, in code, a background tile to the html page output? I have tried the...

Nice - how did you fix this once you did it? I am trying to look up the User ID's now to try and isolate this.

I thought about that but some of the cells within the named range are for users to enter data - some are a formula based on what they entered thus locking down the cells by protection might take some work. I have found a quick way to disable the right click popup menu (ended up being one of the...

How can I set up a workbook so that if a user is editing a cell within a named range then the user cannot insert a row using a right click after selecting the row or going up to 'Insert' then 'Row' on the menu bar. Reason I ask is I have a named range in which is filled with formulas and so...

Sorry about the lack of info, when I started there was only one named cell range (Datebase, SubDatabase did not exist yet) but of course things changed as the spec got more and more complicated. Thanks for the info, worked out well. Will mark a few stars. Thanks. -Q

Thank you of the input, this is starting to work out. What I am doing is I wrote a macro that would insert a new row in a manner in which the formulas that are needed and some formatting is put into the new row. The trick here is there are two diffrent named cell ranges. I refered to them as...

How would I determine when a cell is selected within a named cell range. I have a workbook in which A10:Y400 is named "Database." Assuming a user selected a cell somwehere in the workpage and launched a macro I need to determine if the cell is within the "Database" or...

Well this turned into something. Dale, my email is qritch@hotmail.com I ended up doing what I was going on about above. I have a user form which asks the user to input the item that is getting Gray Shaded. So of course the first thing this does is find if there are any to report a no find...

Oh I will, just need to get some quick code out the door to get this done. You see I am using a user form for the user to enter the value. In doing so I can evaluate the entry to ensure no one does something stupid.

Thanks - found what I was doing wrong. Geoff's reponse was what I was trying to set up for the most part.

I have a large spreadsheet of information, about 3000 lines and growing. The entire "database" is a named range. I have a second named range for a column within the database named range. What I need to do is "gray shade" those rows within the named range when the column...

What are you trying to write?

So I will have to use the other more complex formula to deal with the blank cells. Ok, thanks.

The error did not come from how I entered the array forula. I did use ctrl+ shift+ enter on both instances of the formula supplied above. The main diffrence seems to be the edit I did to the formula. The first formula errored somewhere at the ...1,1,1/COUNTIF... part which I changed to...

Forgot to add that I have an array formula from somewhere else which is largely to complex to run in any reasonable amount of time. =SUM(IF(FREQUENCY(IF(LEN(Tape_ID)>0,MATCH(Tape_ID,Tape_ID,0), ""), IF(LEN(Tape_ID)>0,MATCH(Tape_ID,Tape_ID, 0), ""))>0,1)) Each time the named...

Tried the formula... =SUM(IF(COUNTIF(Tape_ID,Tape_ID)=1,1,1/COUNTIF(TapeID,Tape_ID))) entered and returned an error (#DIV/0!) so I tried this and it worked (did not return an error) but the math is wrong. =SUM(IF(COUNTIF(Tape_ID,Tape_ID)=1,1/COUNTIF(TapeID,Tape_ID))) What could I have done...

I have a column in an Excel Doc. I have the column as a named cell range and I would like to know how to count the values in the range unique so that if the column had below(as an example.) One One Two Three would return the value '3' not '4' as I only want to count the unique instances in...

I would say go with a third party software to filter SPAM out. One thing about all this is the so called "return address" usually changes frequently. So adding addresses and domains to a list might be a time investiment and not completely edit out all those emails that show up. Like...

I am a little new to ADO controls vs. dbase files. I am working with a dbase database. Without Issue I can use the Microsoft ADO Data Control 6.0 (OLEDB) Component and the proper references added to the project. With this I was first using ADODC or ADO Data Control. In this I could reference...