Recent content by DSerr77

Thanks Skip.

Is there an easy way to base the name of a tab on a cell value. I searched the site but can not a related thread any help is appreciated.

Thanks PH That works great, however, I am really trying to understand how do until loops work. any suggested reading. I thought a simple piece of code would help me understand.

Sorry. Fixed It.

I get an Error "Sub or Function Not Defined" when it reaches ExitFor

I am trying to write a simple macro that looks through 20 values and colors the cells until it reaches the value that I have specified. I believe I am having a problem with the "with" section of this code. Any help is appreciated. Sub ColorUntil() Dim A As Range Dim B As Integer A =...

Thanks for the info. This is a annual AP database that contains twelve months of data and usually does not break the 2 GB size limit. Where can I learn how to link databases as mentioned?

I am looking for some help with a database that I use. The database uses 3 large tables and has a few summary queries that pull information from the tables. The problem is that the tables are huge and have brought me to the 2GB size limit. I can no longer compact and repair to fix it. I was...

John, Thanks for sticking with me. I tried using the previous MyVal code and I was getting the auto filter method error. I realize that is because I was testing the code on a one column worksheet. Once I filled columns A-G with data this works great. thanks for your help.

PHV the value of last row = 25014 when I step through.

Autofilter Method of range class failed ??

The filter method looks good but I need that variable to change. My criteria needs to be dynamic.

I need to delete approx 25,000 rows at a time. I think this may be too much too handle.

If you mean Row 65000, The value is null. If you mean of the table the value is 11. However, I have made a minor discovery. I think I have too much data and it just bog the function down. Any suggestions?

CF is meant to select the appropriate range to copy to.