# Search:

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

Page 1 of 6 1

1. ## Thread: CountIF Formula if cell is yellow and has Satisfactory

by MARK858
Replies
5
Views
65

### Re: CountIF Formula if cell is yellow and has Satisfactory

Try putting the code below in a regular module, then use the formula below.
Please note that it will only pick up the standard yellow, if they don't use it then we can change the code so that it is...
2. ## Thread: VBA PasteAll Question

by MARK858
Replies
4
Views
39

### Re: VBA PasteAll Question

What happens if you paste the values and formats separately? i.e.

Workbooks("CB2.xlsx").Worksheets("Sheet1").Range("A3:E500").Copy
With...
3. ## Thread: VLOOKUP help (not SUMIF)

by MARK858
Replies
7
Views
135

### Re: VLOOKUP help (not SUMIF)

Why is it a long work around? you have a list of your unique names and just drag (or if the names are in the next column autofill) the formula down. There are only 3 formula there 1 for the people, 1...
4. ## Thread: CountIF Formula if cell is yellow and has Satisfactory

by MARK858
Replies
5
Views
65

### Re: CountIF Formula if cell is yellow and has Satisfactory

How is the cell coloured with a manual fill or conditional formatting?
5. ## Thread: CountIF Formula if cell is yellow and has Satisfactory

by MARK858
Replies
5
Views
65

### Re: CountIF Formula if cell is yellow and has Satisfactory

You can't as a formula can't detect a colour, you either have to test for the condition that the cell is coloured based on or use a VBA function (and even then it depends whether your cell is...
6. ## Thread: VLOOKUP help (not SUMIF)

by MARK858
Replies
7
Views
135

### Re: VLOOKUP help (not SUMIF)

Why not SumIf :confused: and SumIfs if you want a combination of Person/Product?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
7. ## Thread: Trouble Using Formulas in VBA

by MARK858
Replies
8
Views
141

### Re: Trouble Using Formulas in VBA

As Michael has stated (posted quicker than me)

Set Off_Since = Range(Off_SinceSC, Off_SinceSC.End(xlUp))

is creating a multicell range

but you are using it in Datediff which requires...
8. ## Thread: Trouble Using Formulas in VBA

by MARK858
Replies
8
Views
141

### Re: Trouble Using Formulas in VBA

Post the code as you now have it and tell us what line it errors out on for you.
9. ## Thread: Trouble Using Formulas in VBA

by MARK858
Replies
8
Views
141

### Re: Trouble Using Formulas in VBA

Did you try the change below?

by MARK858
Replies
2
Views
94

### Re: Forgot Password of excel file

As per the forum rule below there is nothing we can do to help you get past the password, all I can say is "Google is your friend".
11. ## Thread: Button to add column to the end of a table

by MARK858
Replies
12
Views
237

### Re: Button to add column to the end of a table

That is why the code by FormR doesn't work for you try

Sub ResizeNamedRange2()
Dim xName As Name
Set xName = ActiveWorkbook.Names.Item("CompTable")
With xName
.RefersTo...
12. ## Thread: Button to add column to the end of a table

by MARK858
Replies
12
Views
237

### Re: Button to add column to the end of a table

FormR's code works fine for me. First of all you describe it as a table then you state "the name of the range is “CompTable”".
So is it an actual table (where you selected the range then clicked...
13. ## Thread: Button to add column to the end of a table

by MARK858
Replies
12
Views
237

### Re: Button to add column to the end of a table

Subscript out of range normally means that something is named incorrectly. Double check that your sheet name and table name exactly match including capitalisation and for leading and trailing spaces.
14. ## Thread: My macro not working

by MARK858
Replies
3
Views
45

### Re: My macro not working

As Joe4 has pointed out the reason your code isn't working is that Fare needed to be all capitals but also you don't need the End If as you are only doing a single test so it can all go on the one...

by MARK858
Replies
5
Views
28

Try
16. ## Thread: VBA Code to Copy All USed Rows

by MARK858
Replies
9
Views
81

### Re: VBA Code to Copy All USed Rows

If you are still having issues try the codes below, the first doesn't include formulas returning "" in the range, the second one does include formulas returning "" in the range.

Sub...
17. ## Thread: VBA Code to Copy All USed Rows

by MARK858
Replies
9
Views
81

### Re: VBA Code to Copy All USed Rows

When I get back in I will hopefully post some code that doesn't retain a memory as UsedRange and LastCell does.
18. ## Thread: VBA Code to Copy All USed Rows

by MARK858
Replies
9
Views
81

### Re: VBA Code to Copy All USed Rows

Despite the various possible issues maybe...

ActiveSheet.UsedRange.Copy
19. ## Thread: Code Not sending email when worksheet range is changed

by MARK858
Replies
2
Views
39

### Re: Code Not sending email when worksheet range is changed

Try running the macro below and see if it makes a difference.

Sub xxxx()
Application.EnableEvents = True
End Sub

Also beforehand go Tools - Reset.

by MARK858
Replies
12
Views
125

21. ## Thread: Finding a date in a column

by MARK858
Replies
12
Views
125

### Re: Hello board - finding a date in a column

EOMONTH takes account of bank holidays and WORKDAY has another parameter you can add for a range of holiday dates.

The VBA for the Find is relatively straightforward (when you are on a PC and not...
22. ## Thread: Finding a date in a column

by MARK858
Replies
12
Views
125

### Re: Hello board - finding a date in a column

Just going out for a few hours so no time to write any VBA but if you were to do it with formula I think the below works so hopefully you can adapt the principle.

<b>Sheet3</b><br /><br /><table...
23. ## Thread: Finding a date in a column

by MARK858
Replies
12
Views
125

### Re: Hello board - finding a date in a column

MrTreasury, if the last day of the month is a Monday (as it is in September) what do you want returned the Monday or the previous Friday?
24. ## Thread: Value not equaling what it should -- can't figure out why

by MARK858
Replies
6
Views
141

### Re: Value not equaling what it should -- can't figure out why

Btw, I think the links Fazza was trying to post are below (somehow there wa a double URL in the links).
...
25. ## Thread: Value not equaling what it should -- can't figure out why

by MARK858
Replies
6
Views
141

### Re: Value not equaling what it should -- can't figure out why

mcomp72, further to what Fazza has stated you possibly have a floating point precision issue, see the link below (hard to tell without seeing all your calculations).

...
Results 1 to 25 of 150
Page 1 of 6 1