# Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1

1. ## Thread: Network Printer Problem

by MartinLiss
Replies
3
Views
286

### Re: Network Printer Problem

I forgot to mention that I'm trying to print an xls file from Excel 2010.
2. ## Thread: Network Printer Problem

by MartinLiss
Replies
3
Views
286

### Network Printer Problem

My wife and I have our own "offices" in our house and she has an HP Office Jet Pro 8710 printer which she shares on our home network. This worked flawlessly for years but yesterday I tried to print...
3. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Zvoni, thank you, that worked! Can you explain how it works? I understand that it is multiplying 3 values that are either 0 or 1 and so in order for the product be 1, all 3 have to be 1, but looking...
4. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Can you attach the workbook you used with the formula in place?
5. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Can you attach the workbook you used with the formula in place?
6. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

That seems to work, but I'm looking for a non-VBA solution.
7. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Sorry I didn't mention it but yes I did, but I would like to avoid changing the structure on the sheet. It was good idea however.
8. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

I'm trying to see if, for example A1:C1 occurs in F1:H1 or F2:H2 or F3:H3. Similarly I want to know if A2:C2 occurs in F1:H1 or F2:H2 or F3:H3, etc.
9. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Application.Calculation was set to xlCalculationManual instead of xlCalculationAutomatic but when I changed it I got this.
171207
Can someone explain how it is supposed work because it looks to me...
10. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Application.Calculation was set to xlCalculationManual instead of xlCalculationAutomatic but when I changed it I got this.
171207
Can someone explain how it is supposed work because it looks to me...
11. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Not for me in Excel 2010.
171205
12. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### Re: Find missing rows

Sorry but that doesn't work; they all say "Missing". Only the "x y z" in row 1 and the "j k l" in row 5 are missing from the range(F1:H3).

I was able to do it with this macro (which I used on the...
13. ## Thread: [RESOLVED] Find missing rows

by MartinLiss
Replies
29
Views
674

### [RESOLVED] Find missing rows

In the attached workbook, what formula can I use that will place "Missing" in cells D2 and D5 because the three values in the left side of the rows are not in the right side of the rows?
14. ## Thread: Unprotect ActiveX combobox on an Excel worksheet

by MartinLiss
Replies
5
Views
444

### Re: Unprotect ActiveX combobox on an Excel worksheet

"UserInterfaceOnly" protects the "interface" but not macros"

Which means that the user can't change protected cells but the code can.
15. ## Thread: Unprotect ActiveX combobox on an Excel worksheet

by MartinLiss
Replies
5
Views
444

### Re: Unprotect ActiveX combobox on an Excel worksheet

"UserInterfaceOnly" protects the "interface" but not macros"

Which means that only the user can't change protected cells but the code can.
16. ## Thread: Unprotect ActiveX combobox on an Excel worksheet

by MartinLiss
Replies
5
Views
444

### Re: Unprotect ActiveX combobox on an Excel worksheet

No, but after a selection is made a cell is filled via code with the selected value.
17. ## Thread: Unprotect ActiveX combobox on an Excel worksheet

by MartinLiss
Replies
5
Views
444

### Unprotect ActiveX combobox on an Excel worksheet

If I have an ActiveX combobox on a protected sheet. The sheets is protected via Sheets("MySheet").Protect password:="Secret", UserInterFaceOnly:=True in Workbook_Open. I have no problem using the...
18. ## Thread: [RESOLVED] Excel 2016 VBA seems to behave differently than Excvel 2010 VBA

by MartinLiss
Replies
1
Views
574

19. ## Thread: [RESOLVED] Excel 2016 VBA seems to behave differently than Excvel 2010 VBA

by MartinLiss
Replies
1
Views
574

### [RESOLVED] Excel 2016 VBA seems to behave differently than Excvel 2010 VBA

I develop if Excel 2010 but I have a user who uses Excel 2016 64 bit. The workbook contains a userform that is displayed non-modally and it contains a button that contains just this code:

Private...
20. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### Re: Need help with a formula

Thanks! With a couple of small changes it gives me what I need.

=IF(OR(D7="",NOT(ISERROR(FIND("day",TEXT(D7,"dddd"))))),1,NA())
21. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### Re: Need help with a formula

Thanks! with a couple of small changes it gives me what I need.

=IF(OR(D7="",NOT(ISERROR(FIND("day",TEXT(D7,"dddd"))))),1,NA())
22. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### Re: Need help with a formula

It really doesn't work with my data. I've attached a small sample workbook.
23. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### Re: Need help with a formula

A formula would be nice but I was able to do it with VBA.

Dim lngLastRow As Long
Dim lngRow As Long
lngLastRow = Range("D1048576").End(xlUp).Row

For lngRow = 7 To lngLastRow
If...
24. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### Re: Need help with a formula

That's, if it's changed to =IF(OR(D1="",NOT(ISERROR(FIND("day",D1)))),1,NA()) it's almost what I need. I believe that formula look for exactly the word day whereas I'd like it to look for day in a...
25. ## Thread: [RESOLVED] Need help with a formula

by MartinLiss
Replies
10
Views
745

### [RESOLVED] Need help with a formula

If column 'D' contains the substring "day" (without the quotes) or is blank, the result should be 1, otherwise the result should be NA().
26. ## Thread: VB - An ActiveX control which supplies a pair of Yes/No Option Buttons

by MartinLiss
Replies
2
Views
7,108

### Re: VB - An ActiveX control which supplies a pair of Yes/No Option Buttons

That is a nice trick, so thanks and I'm adding it to my code snippets library. I don't have any plans to modify the existing code however.
27. ## Thread: Excel: Dynamic Named Range for Row

by MartinLiss
Replies
3
Views
421

### Re: Excel: Dynamic Named Range for Row

Thanks. I should have mentioned that I want to avoid VBA in this case.
28. ## Thread: Excel: Dynamic Named Range for Row

by MartinLiss
Replies
3
Views
421

### Excel: Dynamic Named Range for Row

I currently have the following named range formula

=Sheet1!\$L\$5:\$N\$5

which is for a row and it works just fine fine there are just 3 values, starting in the row at cell L5 to cell N5, but what...
29. ## Thread: [RESOLVED] Excel Formula Needed

by MartinLiss
Replies
1
Views
302

Never mind.
30. ## Thread: [RESOLVED] Excel Formula Needed

by MartinLiss
Replies
1
Views
302

### [RESOLVED] Excel Formula Needed

I currently have this formula

=IF(X4<1,"Expired",IF(X4>=0,"Active",""))

where column 'X' is the result of subtracting two dates. I'd like the formula modified so that if X is blank then blank...
31. ## Thread: [RESOLVED] Row numbers of filtered rows in Excel

by MartinLiss
Replies
2
Views
400

### Re: Row numbers of filtered rows in Excel

Thanks but that doesn't work for me. This does,

With Sheets("MySheet")
For lngRow = 4 To .Range("A1048576").End(xlUp).Row
If Not IsEmpty(.Cells(lngRow, "A")) Then
If...
32. ## Thread: [RESOLVED] Row numbers of filtered rows in Excel

by MartinLiss
Replies
2
Views
400

### [RESOLVED] Row numbers of filtered rows in Excel

I'd like to be able to determine the row numbers of the visible rows after autofilter is applied to a worksheet. How can I do that?
33. ## Thread: RegEx to match two out of three digits

by MartinLiss
Replies
5
Views
536

### Re: RegEx to match two out of three digits

Thanks Ecniv. How would I return the actual matching characters rather tham True/False. In other words
017 ==> 17
637 ==> 67
619 ==> 61

BTW here's part of the VBA I use now which as it turns...
34. ## Thread: RegEx to match two out of three digits

by MartinLiss
Replies
5
Views
536

### Re: RegEx to match two out of three digits

Thanks Ecniv. How would I return the actual matching characters rather tham True/False. In other words
017 ==> 17
637 ==> 67
619 ==> 61
35. ## Thread: RegEx to match two out of three digits

by MartinLiss
Replies
5
Views
536

### RegEx to match two out of three digits

I'm trying to analyze some numbers to find two-digit number matches between two, three-digit numbers. For example if I have "617" in range("B1") is there a RegEx statement that would say that "017",...
36. ## Thread: Using 'Set' in Excel to create a worksheet object

by MartinLiss
Replies
2
Views
381

### Using 'Set' in Excel to create a worksheet object

What are the advantages or disadvantages of using Set wsData = Sheet1 as opposed to Set wsDtata = Sheets("Data")?
37. ## Thread: [RESOLVED] I've never seen this before

by MartinLiss
Replies
9
Views
606

### Re: I've never seen this before

I found that just as (2) puts the value 1 row below the last cell, (5) puts it 4 below, even if there are black cells between previous enttries.
38. ## Thread: [RESOLVED] Excel: Synch two userform listboxes

by MartinLiss
Replies
2
Views
435

### Re: Excel: Synch two userform listboxes

I've given up on this and instead replaced the listbox with a listview.
39. ## Thread: [RESOLVED] I've never seen this before

by MartinLiss
Replies
9
Views
606

### Re: I've never seen this before

A perfect example why "magic numbers" are a bad idea. It never occurred to me that 3 was the magic number for xlUp. Other than that I think it's clever in that it finds the last row in the column and...
40. ## Thread: [RESOLVED] I've never seen this before

by MartinLiss
Replies
9
Views
606

### Re: I've never seen this before

A perfect example why "magic numbers" are a bad idea. It never occurred to me that 3 was the magic number for xlUp. Other than that I think it's clever in that it finds the last row in the column and...
Results 1 to 40 of 500
Page 1 of 13 1

Featured