Search results

What celebrating victory in a war which was waged to lower the tax burden of the rich? I thought it was quite unique to the USA to be honest, though I could be wrong as I haven't researched it.

Ah America's war of independence, what a glorious day, though it had a lot less to do with independence and was more so that rich americans didn't have to pay taxes to the british crown. Still it's an enduring theme in america even today the rich do everything they can to avoid paying taxes.

Did you change any of the code so it was suitable for your spreadsheet?

I don't suppose all the spreadsheets are conveniently located in 1 or 2 folders?

I would suggest asking this on Mr Excel forums there are probably people there who have done what you are trying to do rather than me or someone else here trying to figure it out as we go along. Just remember to post a link to here and let us know if you get an answer.

I'd use an autofilter, something like this: Sub blah() Dim ws As Worksheet Set ws1 = Worksheets("Sheet1") Set ws2 = Worksheets("Sheet2") ws1.UsedRange.AutoFilter field:=1, Criteria1:="<>" ws1.UsedRange.Copy ws2.Paste ws.Range("A1") ws.AutoFilterMode = False End Sub

have you tried removing me.close?

I don't see a warning message being an issue as you can train staff what to do with it as it will be the same message each time, they will have to deal with the macro warning message anyway so I don't see why one more should be an issue. I would usually push back to whoever said it wasn't...

Try turning screenupdating off and setting the calculation mode to manual then turn the screenupdating back on at the end of your procedure and set the calculation mode back to automatic at the end, also probably worth putting in an application.calculate after you change the calculation mode...

Sure, they'll have to employ someone else to write it first though.

Theres nothing in your code posted above that is going to cause the issues you have just described.

Care to explain yourself more so it makes sense?

I'd have to go with iTunes. What a complete piece of shit. I mean really I can only synch my iPod to 1 computer and as far as being a media player goes it is worse than useless. Also fuck off apple I don't want to install your shitty browser or any of your other crapware on my PC. While I'm at...

Change the max value of "i" in the code below to what you need it to be. Private Sub process(ByVal myRow As Integer, myCol As Integer) Dim ce As String Dim AA As Range Dim d As Integer Dim e As Integer Dim BB As Range d = 4 ce = "y" Application.EnableEvents = False ActiveSheet.Unprotect...

I'm in the situation where I now do the work of 4 people, plus my own job. The work of the 4 people who were made redundant have been reduced to 4 macros 3 of which are run weekly and the other monthly, this is all in the private sector.

Depends how you imported them. If they are imported as images then you will have to change the title in a program like paint other wise you should be able to change the title directly by double clicking.

The data validation formula is: =AND(WEEKDAY(B2) <> 1, WEEKDAY(B2) <> 7) not sure how you would do it for an entire column without it taking ages, I would use the change event personally.

Put Worksheets("SheetName").Columns("ColLetter").NumberFormat = "dd/mm/yyyy;@" In the macro after the paste operation.

Trumpet boy delivers his usual quality of advice I see.:rolleyes: Anyway on to your issue. To plot a bell curve based on the mean and standard deviation you use the "NORMDIST" function. See the attached worksheet for an example based on your info.

For your specific question: For Each c In ActiveWindow.Selection If c.Value <> c.Offset(-1, 0).Value Then c.Font.FontStyle = "Bold" c.parent.range(c.offset(0,6),c.offset(0,8).font.bold = true End If Next c For the entire row For Each c In ActiveWindow.Selection If c.Value <> c.Offset(-1...