Search:

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...

In my house we have computers in two rooms at the opposite sides of the house. My computer has the router (from Xfinity) and the my wife's computer is in a room about 35 feet away that we use for an...

I fixed it. I found that under the Advanced options, 'Using system separators' was not checked.

I have one workbook which all of a sudden started showing numbers displayed as 254-789 rather than 254,789. My default language is English and my regional setting is English (United States). When I...

Thanks but what I'm looking for is a way to capture the fact that 'Match Case' (and possibly other options) was chosen in this dialog.
178025

This code wiill display the Word Find dialog. How do I find out which options the user selected?


Sub d()
Dim dlgFind As Dialog

Set dlgFind = Dialogs(wdDialogEditFind)

With dlgFind
...

I have an Epson XP-6100 Series printer and every time I print from Excel it always prints double-sided even if there is only one cell to print. It does not do that when printing from any other...

Thank you for the suggestion. It turns out that my workbook was corrupted and had several print areas that I couldn't remove or repair and I had to rebuild the workbook.

What do you mean?

My zoom is 100%. The problem is that the total width of the 5 columns is less that a full page width so Excel scales up the width to fit the width of 1 page. I think that if I hide the columns to the...