Search results

Hi, Matt, as long as the suitable place for adding is directly under the last entry in Sheet1 everything will be fine. Else you would need some VBA and a UserForm... ;) Ciao, Holger

Hi, Matt, ever thought about freezing panes? The hard way would be VBA but here I´d give the easy way a try... ;) (tried it with Excel97 and it worked). Ciao, Holger

Hi, Johnny, maybe you´ll have a look at the example - I placed the elements into a worksheet as I had no further information if sheet or userform. There´s one checkbox, 2 optionbuttons and 2 listboxes on the sheet with given names and some code like Option Explicit Private Sub...

Hi, DJ100, if you have tested your application more than thoroughly - have a look at EnableCancelKey in the object catalogue / VBA help: Application.EnableCancelKey = xlDisabled Ciao, Holger

Hi, ksaab, have a look at the VLookup function in the Online Help, maybe with an IsError-Trapping to the formula. A1 holds the ID which is located on column A in Sheet2 as well while column B holds the email address: =VLOOKUP(A1,Sheet2!A:B,2,0)...

Hi, shades, I think it´s time for me to get other or more focussing glasses - I didn´t realize that link (sorry for causing inconvenience). Thanks for it - I´ll have to think about that. Ciao, Holger

Hi, qafself, have you already come across Sumproduct? Ciao, Holger

Hi, shades, it would be great if you could spot that disussion. But anyhow I´d never really cared at all for using less ressources - I´m pretty happy if my code is doing what I expect it to do... ;) Ciao, Holger

Hi, shades, so there should be no RTE in the following code according to your explanation as Excel shall convert Integers to Long (sorry if I got you wrong): Dim intRowNumber As Integer intRowNumber = 32786 I pretty much doubt that... Ciao, Holger

Hi, Sup, you should make good use of a loop by using all the columns which are filled - somenthing that may be approached like Sub UsingLoopAllFilledColumns() Dim intColumn As Integer Dim intCounter As Integer Dim lngLastRow As Long Dim lngCounter As Long Dim myArray As Variant Dim bytCounter...

Hi, Sup, the range for the loop is dynamic (as if you are in cell A1 and hit Ctrl + arrow down). It is limited by the first empty row in the column. If you want the whole column you could simply set the upper limit to Rows.Count (which is 2^16 at present) but then you sbould also make good use...

Hi, Sup, your values to compare are listed in Column A while mine where in Column B. Please change one digit in the code to get it working: If InStr(1, Cells(lngCounter, 1).Value, myArray(bytCounter), 1) > 0 Then Ciao, Holger

Hi, Sup, I got it to work by using ="<>Cor*" (Excel2002 SP-3 running on Windows XP PRO SP-2). Put code into a normal module and add further items if needed - please adjust the columns (this works for Column B on the active sheet): Option Explicit Sub SUP() Dim lngCounter As Long Dim...

Hi. Sup, without VBA use the advanced filter: go to a new sheet, copy the headings of the list to row 1 and enter your criteria like ="<>Cor*" one by one in each row. Start the advanced filter from the new sheet indicating the criteria, the new range where you want the data listed, take the...

Hi, Excel-lent, go to Tools / Options General and uncheck R1C1 reference syle. Ciao, Holger

Hi, dfuas, and where did you place the macro? It should be in a normal code module. Anyhow - as no changes are being made to the name of the workbook the following code should do the job: Sub Auto_Close() ThisWorkbook.Save 'will only save workbook with code End Sub And I would prefer to use...

Hi, shades, good job, I didn´t know that. See how long that will stay in my memory... ;) Ciao, Holger

Hi, shades, and what about the prior-Excel97 worksheets which only feature 16384 rows? Please find attached a sample of an Excel5.0 worksheet... Ciao, Holger

Hi, KMaples, when I glance through the options for the data range I do not find an option offering the date: only operations on the number of the data. The only other way of display I know is putting the dates in the column header for each course and finding the data that way - if you can live...

Hi, KMaples, sorry, no - not precisely. Maybe you could attach a zipped workbook with a sample to have a look at? Ciao, Holger