# Search:

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

Page 1 of 6 1

1. ## Thread: imputbox change decimal value dot to comma

by Fluff
Replies
3
Views
20

### Re: imputbox change decimal value dot to comma

Change this
ValorND = Val(ValorND)Otherwise you're converting it to an integer

by Fluff
Replies
10
Views
62

### Re: Formula check

Have a look at Data Validation https://www.excel-easy.com/examples/drop-down-list.html
3. ## Thread: Filter criteria assistance

by Fluff
Replies
3
Views
17

### Re: Filter criteria assistance

Keep getting my logic mixed up, especially with <>
brendanolear
Ignore my code in post#2 & use Dante's in post#3
4. ## Thread: Commence macro from current (not absolute) cursor position

by Fluff
Replies
3
Views
10

### Re: Commence macro from current (not absolute) cursor position

Change both instances of the range with selection, the periodic table sheet will need to be the active sheet.

by Fluff
Replies
10
Views
62

### Re: Formula check

I'm afraid I don't understand, where is your dropdown menu & what type of drop down is it?

by Fluff
Replies
1
Views
17

7. ## Thread: Is it Possible to write a Match Formula with a Defined Name Range?

by Fluff
Replies
6
Views
19

### Re: Is it Possible to write a Match Formula with a Defined Name Range?

Match does not give a count, it simply finds the first match.
8. ## Thread: Is it Possible to write a Match Formula with a Defined Name Range?

by Fluff
Replies
6
Views
19

### Re: Is it Possible to write a Match Formula with a Defined Name Range?

Your named range needs to be a contiguous range, otherwise it won't work.
9. ## Thread: Problem Cycling Through Worksheets VBA

by Fluff
Replies
3
Views
21

### Re: Problem Cycling Through Worksheets VBA

That entirely depends on the code located at
10. ## Thread: imputbox change decimal value dot to comma

by Fluff
Replies
3
Views
20

### Re: imputbox change decimal value dot to comma

If InStr(1, resposta, ".") > 0 Then resposta = Replace(resposta, ".", ",")
11. ## Thread: object variable or with block variable not set

by Fluff
Replies
6
Views
28

### Re: object variable or with block variable not set

Cheers :beerchug:
12. ## Thread: Data validation - dynamic and also dependent on a particular column

by Fluff
Replies
14
Views
165

### Re: Data validation - dynamic and also dependent on a particular column

When using < or > symbols you need to add a space either side, otherwise the board thinks that you are posting HTML code.

by Fluff
Replies
10
Views
62

### Re: Formula check

Is your dropdown a Data Validation dropdown?
If so what cell is it in?
14. ## Thread: Extracting data from within multiple square brackets

by Fluff
Replies
9
Views
80

### Re: Extracting data from within multiple square brackets

You're welcome & thanks for the feedback.
Have a good weekend yourself. Certainly looks like we've got the right weather
15. ## Thread: Filter criteria assistance

by Fluff
Replies
3
Views
17

### Re: Filter criteria assistance

Try
.AutoFilter 16, "<>East", xlOr, "<>West"
16. ## Thread: Commence macro from current (not absolute) cursor position

by Fluff
Replies
3
Views
10

### Re: Commence macro from current (not absolute) cursor position

Change
Range("N26:N34")to
Selection
17. ## Thread: object variable or with block variable not set

by Fluff
Replies
6
Views
28

### Re: object variable or with block variable not set

You're welcome & thanks for the feedback.

Please note post#3 for future reference.
18. ## Thread: Calculating all numbers by name.

by Fluff
Replies
1
Views
13

### Re: Calculating all numbers by name.

Have a look at the SUMIF function. https://exceljet.net/excel-functions/excel-sumif-function
19. ## Thread: Extracting data from within multiple square brackets

by Fluff
Replies
9
Views
80

### Re: Extracting data from within multiple square brackets

Then in your worksheet you enter...
20. ## Thread: object variable or with block variable not set

by Fluff
Replies
6
Views
28

### Re: object variable or with block variable not set

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1287516-object-variable-or-with-block-variable-not-set.html#post5181984

While we do not prohibit Cross-Posting on this site, we...
21. ## Thread: Copy cells (values & Formatting) from one worksheet to another.

by Fluff
Replies
3
Views
19

### Re: Copy cells (values & Formatting) from one worksheet to another.

It should do exactly the same as your code.
22. ## Thread: Need help on VBA Excel to copy paste value

by Fluff
Replies
2
Views
39

### Re: Need help on VBA Excel to copy paste value

Change this
.Range(.Cells(2, "A"), .Cells(lr, "A")).Copy DestSh.Cells(2, "A")

to
DestSh.Range("A2:A" & lr).Value = .Range("A2:A" & lr).Value

And the same thing for the other two columns
23. ## Thread: object variable or with block variable not set

by Fluff
Replies
6
Views
28

### Re: object variable or with block variable not set

Hi & welcome to MrExcel.
I suspect that this line
Set foundRng = Folha10.Range("A2:A400").Find(NumRecibo)is not finding the value of NumRecibo and therefore foundRng is nothing
24. ## Thread: Copy cells (values & Formatting) from one worksheet to another.

by Fluff
Replies
3
Views
19

### Re: Copy cells (values & Formatting) from one worksheet to another.

Hi & welcome to MrExcel.
Sub Philnblanks()
With Sheets("JUNK")
.Cells.ClearContents

Sheets("ONGOING!").Range("A1:T10").Copy
.Range("A1").PasteSpecial...
25. ## Thread: [VB help needed] Copy mulit folder files to Destination based on excel

by Fluff
Replies
30
Views
567

### Re: [VB help needed] Copy mulit folder files to Destination based on excel

Simply add the _ to the file name in col A so that it looks like 859_ or 859A_
Results 1 to 25 of 150
Page 1 of 6 1