Search results

This code goes into the code for worksheet where you want conditional formatting ("Work" on attachment). Right click on the worksheet name and choose "View Code". In the resulting VBE window (on the right side) at the left top make sure that the dropdown is "Worksheet" and top right dropdown is...

Regarding the 2007 issue and transferring files, I think the only solution is VBA. I will say that the code I will post later never did slow down my spreadsheets (about 30 worksheets, four of which used the worksheet code). ________ Honda Pilot (ATV) specifications

Yes, it can be done rather easily using Select Case. I can post an example code tomorrow which allows automatic updates (worksheet code), and background sheet to change the colors (if necessary) without adjusting the VBA code. ________ Vaporizer Affiliates

Howdy. I assume that the new name will go to the end of the list. As a starting point, record a macro to add a new worksheet and rename. See what code is produced. Then we can work from there. ________ Honda Civic (Seventh Generation) Specifications

Do you have WinZip on your computer? If so, then to zip it, in Windows Explorer, select the file, right-click and choose WinZip > Add to Zip file. Otherwise, occasionally, I have done the work in Excel, close and in Windows Explorer, changed the extension from .xls to .doc. Then post it to the...

Howdy. Can you perhaps provide this in a spreadsheet already? Don't need all the rows, just enough to have the variety of results needed. ________ Washington medical marijuana dispensaries

One caution: you want to find out whether that gives the last cell based on top-down search or bottom-up search. They do not necessarily return the true "last cell". ________ HERBAL VAPORIZERS

No, merged cells are the worst. :) ________ WEBSITE HOST

The problem with doing this: lastrow = ws.range("B1").End(xldown).row is you might run into a blank space, then your code will give incorrect results. ________ ROBERT B. EVANS

Howdy. Yes, Pivot tables could solve what you need. And if you need a chart, you make a Pivot chart as well. ________ Chrysler Ja Platform

If you buy a new Mac, you can use Parallels and run Windows with Access on it (If you dont' find an alternative). ________ Buy Mflb

Howdy. You can add a couple of steps to find the next row after last entry. Dim lngNextRow lngNextRow = Work.Cells(Rows.Count, 2).End(xlUp).Row + 1 Set rng = Range("B" & lngNextRow) ________ TOYOTA WISH HISTORY

Just a note. It is better (and more efficient) to not use Integer but as Long. Excel actually converts Integer to Long anyway. And if you have more than 32,000 rows, Integer will not suffice. ________ BUY AROMED VAPORIZER

Howdy. Have you checked whether the spreadsheet is protected? If not, it is probably protected or that capability is prevented by VBA. ________ VOLCANO CLASSIC REVIEW

The MATCH formula is looking for the row number of last item. 9.99999999999999E+307 is the largest number that Excel can handle. When you search for this value using an approximate lookup (i.e., when MATCH's 3rd, optional argument is 1 or omitted or TRUE) then the last value in the lookup array...

I agree. The number becomes a handy tool for many uses as a defined name. And with slight modications can be used for number of prints, version control, etc. (primarily in VBA). ________ Top penny stocks

Howdy. If you have XL 2002/2003, then you can. In the Pivottable where you have that list, right click and choose Field Settings. Then in lower right corner, choose Advanced. On the left it gives you the option to sort ascending or descending or Manual (default). ________ INFERTILITY FORUMS

I picked that up several years ago (I think soon after we moved to XL 2002). Regarding your approach, I have done that. But now if I had to do that on several sheets, it might be worth it to name a number, Nbr and define it as =1 Then you could use the formula: =B1*Nbr That number can...

Yeah, I learned this from Aladin - brilliant Excel formulist... ;) Actually, if this occurs more than once in a workbook, then it is wise to name the number as BigNum =9.99999999999E+307 Then the above formula becomes =INDEX(B:B,MATCH(BigNum,B:B),1) ________ Herbalaire

Howdy. The are in fact text, any time they come from databases, regardless of how they are formatted. If you don't need leading 0's, then you can type the number 1 in a blank cell outside the range, then select that cell and copy it. Then select entire range of "numbers" to be converted, and...