Search results for query: *

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.

John, That code works great in a test file, the minute I try to put in in the real file it goes belly up. It looks like a continious loop. Similar to the problem I mentioned before. Any idea what could cause that to happen? Thanks.

Here is an exzample of the worksheet's structure: Name Amount 1 Amount 2 Test 1 1 Test 1 Test 1 Test 2 2 Test 2 Test 2 Test 3 3 Test 3 Test 3 Test 4 4 Test 4 Test 4 Test 5 5 Test 5 Test 5 Test 6 6 Test 6 Test 6 Test 7 7...

Here is what I have put together so far. Sub CFD() ' ' CFD Macro ' Macro recorded 12/5/2006 by Frontier ' Dim xcol As String Dim ycol As String Dim ROS As Integer Dim CF As Range ' Set xcol = Columns(4).Count Set ycol = Columns(5).Count Set ROS = ycol - xcol...

I am trying to find a piece of code that will neable me to automatically copy formulas from a range of cells (that will change) into a given range of cells (that will also change). I am adding data to the bottom of a list and need to paste a group of look up formulas to the left. The number of...

I have tried this so many times and have had numerous people look at it. Evryone thinks it should work and the original code does work, could it be something in the sheet name?