Recent content by hawley

Thanks for the suggestion. I do understand Named Ranges and use them often. I was just trying to understand how to do this before I added named ranges into the equation.

Thank you all for the suggestions. kwbMitel - I tried vlookup but because the column I want to look at is not always the frist column vlookup wasn't working. Skip - I will look at MS Query and see what it does. Thanks. I did get another solution on a different forum that worked as...

I forgot the headings in my example...sorry about that. You are correct in what you have for headings though. My only question with your formula is are you putting that formula in C2 on the Reference sheet? If so that is not really what I am looking for, unless I misunderstand. C2 on the...

My brain is out of ideas so was hoping someone else had a thought or could nudge me in the right direction. Here is what will happen: 1. Data is dumped from a database and will be put in the Data Worksheet (columns A-D). 2. Column D from the Data worksheet will be copied and paste into the...

I have a sheet that contains values that I will use for the data validation list. When I run this code the list cuts off. Is there some sort of restriction when creating the validate list for a drop down? My list is not reaching 65000 characters which is the string cut off. Code: Dim...

Thanks for all the help. I ended up making my second solution work. When I kept the variables as numbers they compared to each other correctly.

Didn't see the code was not wrapped correctly...here is the post again...a bit cleaner. MarcLodge - I figured that as my issue after seeing fredericofonseca post. I will try the dynamic sql as well. Thanks for the help Here is something I was trying this weekend. I was just passing in a...

Here is something I was trying this weekend. I was just passing in a store in a seperate variable and then comparing it to the result from the sql. My issue with this is for some reason my if statement is wrong. Any ideas and/or suggestions would be helpful. [code] *definition in the...

Thank you both for replying. mikrom - I have tried to debug but we have changed our debugger and I didn't know what I was doing. I will have to ask for help today on how get things started. fredericofonseca - If I understand you correctly then what I am trying to do will not work. Here...

This may belong in the DB2 forum but I am using this with COBOL so put it here. I have a fun problem. I have a COBOL program that is retriving a list of numbers from an Oracle database. Each time it retrieves a new number it puts that number in a comma delimited string with single quotes...

I was finally able to try that if statement but it didn't work. I still had a grey line when all that was in the body was: <div xmlns:st1="urn:www.microsoft.com/smarttags" xmlns:o="urn:www.microsoft.com/office" class="rxbodyfield" xmlns:x="urn:www.microsoft.com/excel"...

Thanks for your help but I am a little confused. I am just starting on xsl so I am not sure what you mean by a trace. I will always have this code in the body text.. <div xmlns:st1="urn:www.microsoft.com/smarttags" xmlns:o="urn:www.microsoft.com/office" class="rxbodyfield"...

I have just gotten thrown into html, xml and xsl code so please ignore my basic knowledge. I have a content management system that creates html, xml and xsl code. It is a tool where a user will enter data into fields and then an html page will be created. When they enter data and enter...

I am just learning html and style sheets so I am not sure of how everything works. I am trying to create a style sheet with the following class: body.standard_format { background-color: #ffffff; margin-left: 0; margin-top: 0; margin-height: 0; margin-width: 0; font-family: verdana...

I hope this is the correct area to post this question. If not sorry, if so please help. I have looked every where and can find nothing. I am trying to work with making a check box a halfchecked check. By doing this I need to use the ThirdState Property. The way I have it set up is 0=off...