Search results for query: *

That does the trick, thanks!

I'm trying to write some code to select a case based on an interval of time. For example, if the value in the cell is between 8:00 and 8:59, I want it to shade a certain color. However VBA does not like time formats in the case statement, at least the way I'm writing it. Case 8:00:00 To 8:59:00...

Thanks again. It's not telling me where the error is happening, it's just giving me an invalid procedure and call arguement. The code is the same as my first post except I have defined the Target as a Range variable.

Thanks Skip. Excuse my lack of knowledge, but I'm learning VBA on the fly. I previously tried defining target as a variable and it didn't work, but your nudge helped me look a little more and find the colorformat variable. Now I'm getting a problem with that last statement before END IF, if I...

Hi, I see there's someone having a similar problem in the thread down below, but unfortunately it's not helping me figure out what's going on with my code. I'm trying to conditionally format cells based on input values. I keep getting an object code required error when I run the following code...

Thanks. I was getting a duplicate error when I was renaming the wksht variable for each spreadsheet, so in my mind I needed to rename them. But after your reply it hit me that I only need to name the variables one time. Thanks again!

I'm trying to expand on some code written by a previous person. I'm trying to have the macro identify up a defined date variable (uRepsonse)from 3 different spreadsheets. It works fine on the first sheet (this was the original code). I tried to copy the code for the 2nd and 3rd sheets, but on...

Hey, I think that will do it if I can put my date variable as the starting point of myrange.

Not too much, but I can do some reasearch. Thanks for the help.

I apologize if I'm not clear. I'm having the macro find a date formatted like (20080627) somewhere in a workbook, and I'm good with this code. Then I'm having it move over two columns and down three rows, and then I need to select a range that is in a block format, the data in that range may or...

Let me also add that the data isn't contiguous most of the time. I just need it to pick up those block of 60 cells wherever they may be in the worksheet.

I'm trying to program a macro to pick up a variable range of data and copy it. I'm doing this by having the macro find the date in the workbook and pulling the data adjacent to that date cell. The copying part is not the problem, it's how to define a range of data without specific cell...

Hi, Some time ago, someone helped me with the following code. What I am trying to do is find a cell based on a date given (uResponse), and then importing data from another sheet adjacent to that cell. This code works just fine. However, now I want to do this to more than 1 sheet, and I'm having...

Thanks, I'll check it out.

Makes sense I think. So it will just find the next value by default?

Hi, I've created a macro to ask for a value (via msg box), then find the value in a worksheet and then it brings in the data on the same row as that value. I now need to modify it because the response will be in multiple sheets, so I need it to find the response in sheet 1, then do it's thing...

It is dimmed as a string, but it still wouldn't cancel out when clicked.

Thanks for the help. I was close with everything I tried, but I couldn't quite get it.

Obviously I mistyped, the directory in the last two commands, so disregard that. Thanks.

I'm new to VBA programming, and I'm having trouble with getting the input box to close when the cancel button is clicked. If anyone has any suggestions, it would be much appreciated. Thanks, Garrett Message = "Input the date which you want to update. The format must be YYYYMMDD." TitleBarTxt...