Search results for query: *

Thank you for the suggestion, i'll look into it [wink]

Hi SkipVought and mintjulep, Thank you for pointing me in the right direction. Referencing to just one column did the trick. I should have found this myself....

I have an excel sheet with a list of dates and I want to find the matching row for a date in another sheet. The list of dates are formatted as dates, not as text... Example: In sheet1 I have a text value in cell A2 like "2022-08-29 09.58.51" A formula in cell B1...

Thank you SkipVought, You've pushed me in the right direction ;-)

Hi Combo, Sorry for the late reply. Your option in the other forum did not work for me either. I've multiplied the numbers with E+10 and mentioned in the header row that the values are shown as E-10 like shown below. Intensity(A) (*E-10) 0.0401 0.092 331.5145 0.0398 0.0135 284.0515

How do I write the range ActiveSheet.Range(A5:B5,D5:AM5) using the cells notation ? I want to define the range using row numbers and column numbers...

Thank you for your support but this was not what I was looking for, unfortunately. Using this notation, the result is not a number anymore I can make a calculation with :-( I've solved it another way, but thank you anyway

How can I format values to always display as xxxx E-10 So not just a scientific notation but specific E-10

How can I display all values in a excel sheet as xxxE-10 Not just scientific notation but specific as E-10

I have a 3th party COM addin which gives a split button in the "message" toolbar in Outlook. Now I want to execute the upper-button using vba, is that possible ? I can not add the addin to the reference of the vba project !

After the update from last week several buttons don't show up anymore in a personal Excel toolbar created in the CustomUIEditor. This is the part of the working code before the update: <group id="grpFavorites"label="---OFFICE TOOLS ---"> <button idMso="FileSave"size="large"/> <separator...

Im setting up a website using wordpress and I want to create a "digital PObox" to put result files in for specific members. So the logged user can only access that file and no-one else. Is there a good plugin I can use to achieve this option ? I'm not a experienced user ;-)

I have a combobox populated with an array declared as variant. A part of the array looks like: 156727 C. v. Staveren 158552 B. Stevense 194042 P. Strijbos 169968 E. Strucks 40406 C. Swens F195909 A. Ticheloven The combobox is set to show the first column Typing F the...

Very strange .... If I use the code below it also works Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("test") DbaseArray = ws.Range("A1:K100") Very strange...

Yes it is... I get this error on 3 different systems now in office 2016 It seems that the combination sheets("test") with .range causes the problem...??

Using the code below does also work but I'm wondering whats wrong with the first code... ThisWorkbook.Sheets("test").Select DbaseArray = Range("A1:K100")

Type mismatch (error 13)

I get an error using the code below.... DbaseArray = ThisWorkbook.Sheets("test").Range("A1:K100") leaving out the first part ThisWorkbook.Sheets("test"). the code is correct ??!! But I need to point to that specific sheet... Am I missing something ? The Sheet "test" does exist !

Hi Skip, Sorry for the late reply... Off course I can use the case option but in your suggestion you read the data from the sheet named "template" and that is just the sheet I want to exclude

Hi SkipVought, Yes I realize that all cells within the named range SerieDateArea filled with a date wil be stored in the array, that was mend to be. I've solved the problem adding another field in the array so I can store the sheet name and cell address separately. counter = 0 For Each ws In...