Replies

Thanks, Hans.

After reading the link and fumbling around quite a bit, I still cannot figure out how to copy the holidays. I found the Outlook.hol file and modified it to contain only US holidays and made it an Excel file. However, I could not Import it. When the Import wizard asked for me to Select a Destination, the Public Folders were not there to select.

I’m sorry for being so dense …

–cat

Thank you very much, Hans.

Sorry, Legare … I forgot to add that the users will be trained to select entire rows (and the rows will always be contiguous). What I actually needed was a row count of this row selection.

Thank you both for your help …
–Cindy

Thanks, Steve. That works. But even better, the Selection.Rows.Count is actually what I’m after (i was going to calculate it by EndRow-StartRow)!
Thank you,
–cat

Thank you both every so much.

I can now “count” columns AND shorten my code tremendously by not selecting the sheet first!!!

I am learning so much from this site!

–cat

That did it !!!
You’re wonderful
–cat

Hi Hans (and others) …

I used the workaround solution noted in your link regarding Runtime Error 1004 …
This workaround has you create an excel template with that sheet in it (the sheet I was trying to ‘copy’ in the first place)
And, you perform a “Sheets.Add Type:=pathfilename …. instead of the copy.

Well, it works fine. No crashes and completes the job.
But, it is very, very slow because it appears to be performing a virus scan (so says the Status Bar) each time it adds that sheet via the Type method.
In my (close to an upper-limit) case, the sheet was added via the Type method 144 times and took about 10 minutes …

Perhaps, I can turn off “Virus Scan” for this particular template ??? … but, that just sounds wrong. And, if it was easy, it would also sound scary.

Any suggestions … otherwise I will live with this performance issue since it is only used once per project ..

Thanks,
–cat

Thank you, Hans.

It is not the first post (re the Sheet11111111) … however, it is excactly the Runtime Error 1004 issue.
I will try saving the file during this. If you don’t hear from me again … it will be working.

Thank you, again.
–cat

Hi Hans,

In another macro, the formula “=E8” was placed in cell AH3. Please note, though, that E8 is not always constant .

The formula was placed using:

Range(“AH3”).formula = “=E” & nextrow

to place the formula.

Now, I need to know that row number …
I cannot get to this macro in order to keep track of the row number when the link is placed in cell AH3 … which would be the best way to do this.

So, I was wondering if there is a way to “pull” the row number out of the formula. The “E” will always be the same …

Does any of this make any sense?

Thank you very much for your time and effort …

–cat

Hi Catherine,

The Row function gives me the number 3 … since the cell is AG3.

I need to grab the ‘8’ from the formula ‘=E8’

Thanks,
–cat

Thank you, Jan, for figuring out why the long way didn’t work for me …

–cat

Thanks, Steve,

Defining the name the shorter way … works! The other way didn’t work with or without the sheet name.

Again, I’m in debt …
–cat

Don’t worry about this one, please. I have figured another way to do the same thing …

Thanks,
–cat

Thank you both, Hans and Steve, this is what I needed!
–cat

Thank you thank you thank you, Hans

That worked wonderfully …
–cat