Search:

Type: Posts; User: DanteAmor; Keyword(s):

Page 1 of 6 1

1. Thread: Conditional - multiple conditions

by DanteAmor
Replies
7
Views
98

Re: Conditional - multiple conditions

Do you have an empty cell or a blank space?

Try this

=SUM(IF((TRIM(B1:H1)<>"")*(B1:H1<>0),1,0))+SUM(IF((TRIM(J1:W1)<>"")*(J1:W1<>0),1,0))=21

by DanteAmor
Replies
9
Views
146

Good luck
3. Thread: Count if formula required

by DanteAmor
Replies
2
Views
108

Re: Count if formula required

I changed the dates from 25jun to 26jun to perform the tests and my results do not match your example.
You could comment.

<table style="font-family:Arial; font-size:12pt; border-style: groove...
4. Thread: How can I find the range in which is cell falls when the ranges are not continuous?

by DanteAmor
Replies
1
Views
60

Re: How can I find the range in which is cell falls when the ranges are not continuous?

You could explain with real data what you have on each sheet and the expected result.
5. Thread: Macro to create a new row and copy data

by DanteAmor
Replies
1
Views
56

Re: Macro to create a new row and copy data

Try this

Sub Create_New_Record()
Dim u As Long
Application.ScreenUpdating = False
For i = Range("A" & Rows.Count).End(xlUp).Row To 1 Step -1
If LCase(Cells(i,...
6. Thread: Moved PDFs from one location to another

by DanteAmor
Replies
6
Views
79

Re: Moved PDFs from one location to another

Try this.
Change data in red by your information

Sub SaveasPDF()
Dim wsA As Worksheet, strName As String, strPath As String, strPathFile As String
Dim wUser As String, wDesk As...
7. Thread: Missing End If error

by DanteAmor
Replies
19
Views
255

Re: Missing End If error

Okay, let's wait for the tempest to subside.

Also, you have a great day.

by DanteAmor
Replies
6
Views
79

delete

by DanteAmor
Replies
4
Views
61

10. Thread: Easier way to write this?

by DanteAmor
Replies
3
Views
87

Re: Easier way to write this?

I did not understand what the pattern is.
But try the following.

Sub testerdelete()
Application.ScreenUpdating = False
Application.EnableEvents = False
ActiveSheet.Unprotect

by DanteAmor
Replies
6
Views
44

12. Thread: Return Cells in a Sequence that's Greater then Zero

by DanteAmor
Replies
4
Views
61

Re: Return Cells in a Sequence that's Greater then Zero

Try this array formula

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
13. Thread: Index and Match values in a cell seperated by commas

by DanteAmor
Replies
3
Views
98

Re: Index and Match values in a cell seperated by commas

Hello, it is not clear if you have the data on a sheet or in several sheets.
I also do not understand if the result is on the same sheet or on another sheet.

I understand that in cell A1 you...

by DanteAmor
Replies
4
Views
70

15. Thread: vba code doesn't work; same code works as a macro

by DanteAmor
Replies
6
Views
44

Re: vba code doesn't work; same code works as a macro

You can put your complete code here.
What do you have in the variable naamSp?

Do you want to copy the formula or take the value?
16. Thread: Conditional - multiple conditions

by DanteAmor
Replies
7
Views
98

Re: Conditional - multiple conditions

Select cell A1 and in conditional format, in formula put the following:

=SUM(IF((B1:H1<>"")*(B1:H1<>0),1,0))+SUM(IF((J1:W1<>"")*(J1:W1<>0),1,0))=21

It works for any value in the cells...
17. Thread: VBA Coding - Excel keeps crashing

by DanteAmor
Replies
2
Views
72

Re: VBA Coding - Excel keeps crashing

Try and tell me.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B:B")) Is...
18. Thread: Excel2016. Return several criteria for an article as text

by DanteAmor
Replies
1
Views
75

Re: Excel2016. Return several criteria for an article as text

Try the following UDF.
Put the code in a module and use the function as shown in the following example:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt;...
19. Thread: VBA to Copy Specific Cells into all Worksheets

by DanteAmor
Replies
1
Views
53

Re: VBA to Copy Specific Cells into all Worksheets

Try this

Sub NewSheets()
Dim sT As Worksheet, sD As Worksheet, i As Integer, sN As Worksheet

Application.ScreenUpdating = 0
Set sT = Sheets("Template")
Set sD =...
20. Thread: Look-up from 2 excel files.

by DanteAmor
Replies
4
Views
70

Re: Look-up from 2 excel files.

Try this

=IFERROR(INDEX('[Product Masterfile.xlsx]Sheet1'!\$C\$8:\$C\$65536,MATCH(L1202,'[Product Masterfile.xlsx]Sheet1'!\$E\$8:\$E\$65536,0)),IFERROR(INDEX('[Archive Product...
21. Thread: Find cell value using multiple criteria and a header row that does not always have a value

by DanteAmor
Replies
3
Views
80

Re: Find cell value using multiple criteria and a header row that does not always have a value

That's right, the Z10 is the final cell.

In my example, row 2 contains the codes, and row 3 is empty, so add 2 to start with the prices.
22. Thread: Moved PDFs from one location to another

by DanteAmor
Replies
6
Views
79

Re: Moved PDFs from one location to another

Your macro only saves the active sheet in PDF:

Set wsA = ActiveSheet
wsA.ExportAsFixedFormat _

I do not know why you select the sheets in this part:
23. Thread: Insert New Row From Drop Down

by DanteAmor
Replies
6
Views
170

Re: Insert New Row From Drop Down

Sorry, but I still do not understand.
This has to do with the original requirement or is it a new request?
24. Thread: Missing End If error

by DanteAmor
Replies
19
Views
255

Re: Missing End If error

I'm sorry, but I do not understand what you want me to help you with.
You can explain how it works, which sheet I go to, which form, which macro.

Explain in detail and with examples, especially...
25. Thread: 3x Checkboxes - Hide/Unhide sheet

by DanteAmor
Replies
13
Views
185

Re: 3x Checkboxes - Hide/Unhide sheet

Sorry, but I do not understand.
You can tell step-by-step what to do in your file and what you expect in each step.
Results 1 to 25 of 150
Page 1 of 6 1