Search:

"Good" to know. Thanks.

I just started using Excel 2019 and I have a small problem. In my old Excel 2010 when I open a workbook I see something like this where I can use controls in the upper right-hand corner of the...

Thanks (and I really mean that) but the first link applies only to Word, I know how to do the second but it doesn't answer my question, and the 3rd, while valuable, again doesn't answer my question.

Given a table in Excel, how do I determine what the color of the header is? What I'm trying to do is if a row in table2 = a row in table1, color table2's row the color of table1's header.

I figured it out again.

westconn1, what I thought was a solution didn't actually work properly so if your still willing to look into it I'd appreciate it.

To answer your questions, there is no priority among staff...

Thanks for looking at this but as I woke uo this morning I had an insite that will allow me to complete this.

The attached file is a staff scheduling tool for assigning staff to "slots" in 6 cafeterias. Each cafeteria has two shifts every day except Friday where there is no PM shift.I'm having great...

I have a range that contains 90 non-contiguous cells and I'm trying to use Application.WorksheetFunction.CountIf to return the total number of cells with a specific value but I keep getting syntax...

Thanks westconn, that works.

No I don't. The actual range however is longer and I want to avoid code like this

For lngRow = 1 to 50
MyString= MyString & Cells(lngRow, "A")
Next

If I have 9 in cell A1, 8 in cell A2 and 7 in cell A3, is it possible to create a string with the value "987" without looping?

Thanks. I'm going to use the formula approach you pointed out.

That's true but I'm willing to risk that. And thanks for the link. I may use it.

The opm.gov website has list of US federal holidays that I would like to import into Excel. I know that I should be able to use the 'From Web' button on the Data tab, but I have a very old browser...

No, since it works in VB6 so shouldn't it work in Excel. Excel's Add-In Manager shows me this
179609
while VB6's shows me this.
179610

I have an old XP machine and on it are both VB6 and Excel 2010. I used to use MZTOOLS 3.0 in both of them but I had a problem with Excel and MZTOOLS no longer appears in the Add-In Manager. How do I...

Thanks but mu "latest" version is XP, and because of a problem I don't even have that any more.

I just had Windows 10 installed via an ISO file. What is the best way to get a license key?

The workbooks need to be visible which they weren't. After that it's simple.


For Each ws In wbSource.Worksheets
If Left(ws.Name, 3) = "tab" Then
ws.Copy...

I have some code which opens a source workbook and assigns it to a wbSource object and opens a destination workbook and assigns it to a wbDest object.

My aim is then to copy some of the sheets...

I have the following code which is used to translate the text in a worksheet's cells from any language to English. It is called from a For-Each-cell loop. It works most of the time but once in a...

I have a worksheet that contains random words and phrases in several non-English languages, plus dates and numbers. The "Translate" sub in this code which I found on the web drives the process of...

Strange question i know, but is it possible for my wife and I to have a video chat between ourselves on our macs over our home network?

Ignore - sorry.

In my code I'm filtering on column "X". In the code below column 'X' is represented by COL_CONCAT. If I open the workbook and run the code it works as expected but if I try it again it doesn't and I...

I believe I found the solution and it's kind of embarrassing but I think I owe it to the people who tried to help me and explain what the problem was.

As I mentioned above I've worked with Excel...

Thanks but I don't think I can do either of those things because of my For lngRow/Next loop. As I said I have a workaround that I don't want to change, but I'll actually test your suggestions when I...

Impractical.
Absolutely. As I said, I was recording macros (and looking for then) for over 10 years until I manually created my first Personal.xlsb file,

jdc2000 your other 3 links talk about deleting it but I already did that. After that it comes back when I record a macro. I'm guessing now that there's some registry setting I set to "On" when I...

Please see my "That's not true" comment.

That's not True. For 10+ years I recorded macros and they always recorded in the current workbook and Personal.xlsb was not in my VBAProject window.

What didn't work was clicking 'Hide' as...

Thanks but that didn't help.

As an experiment I created a Personal.xlsb file for myself to see what it was like using one. I wasn't happy with the results so I deleted it. After that it doesn't show up in my VBAProject window...

Understood and that's the first thing I thought of but there's a lot of code in my actual sub that refers to the same worksheet and I believe that using the ws object is a lot more efficient.

I guess I deserve that:)

I assume (and hope) you can tell that the code that I originally posted is not my actual code but just a simplified example. In any case when the equivalent of lngRow...

I found a workaround.

I'm hoping someone can help me with this annoying little problem. I have a shape in Excel 2010 that has a macro assigned to it and recently the mouse pointer has started to flicker when I simply...

You can see similar behavior in loops. For example the output of this code

Sub test()
Dim lngLastRow As Long
Dim lngRow As Long
Dim ctr As Integer

lngLastRow = 10

For lngRow = 1 To...

I don't think it's possible to do, but I have code that has this structure.


Set ws = Activesheet
With ws
For lngRow = 2 to 1000
If lngRow = 100
'Code to create a new...