Recent content by Marisoleil

I tried this, but ... well, one hour later... program was still running but no results. Not sure why: could it have been too time-intensive of a loop?

Thanks, Bob. Yes, this is the right idea, except the number of cells is going to vary, so I would like somehow to say: this cell OR this cell OR this cell... until the end of the occupied rows in this column I was thinking I would have to populate an array, and started to play around with...

Hello, I want to modify the following slightly so that intLineCount variables are not specified number values, but rather are numbers taken from the contents of a column of cells within a specific Excel workbook sheet. (The number of values (non-blank rows) in the column will be different each...

:D I did up until sixty seconds ago! The last If-Then-Else had a strange quirk when executing the Else condition: the code explicity states for the copied data (from fname2) to be pasted to workbook fname3; however, it was being pasted to workbook fname2 (the same workbook the data was copied...

Hi Again Macropod, Sorry to add to that last post: I did try that 'Offset' line exactly as you had posted it first. When it bugged, then I tried altering the command to the form you see as I last posted it. Cheers, Marie

Hello Macropod, Many Thanks! There were a few little adjustments I was able to make, but just one remaining problem. Maybe you could offer further thoughts on: Workbooks(fname3).Sheets("Sheet1").Range("A1").Offset(.Cells.SpecialCells(xlCellTypeLastCell).Row, 0).Paste It's the line right...

Hi Macropod, It worked, yes, but still bugged at the end on the empty (displayed value) cell. You have got tenacity and generosity of spirit, if you are willing to look at this again, or maybe just a mind for puzzles. Thanks, Marie

Hi Again All, I've been at it for a few hours today with this code and have taken some steps forward and some back. Bob: To answer your question, the contents of Row 18, Col 6 is an If-Then formula which displays within the cell a URL address. (See my most recent message before this one in...

Hello All Thanks again for suggestions and tips, and for the great editing, macropod. Very helpful for me for learning, I went through all the edits. The bug is still in the program though. What could the issue be at this point? Bob Rashkin, I did try your suggestion, just to see. Same...

Thanks for responses and suggestions. I'm still having trouble, and I have read over my original post and see that I erred in describing the situation in a tiny way: I don't have '0' in the cell at which I want the loop to stop, but it's simply a blank cell displayed. Does this change things...

Hi Yogi, Thanks for code suggestion. Well, I tried it, but I am still gettting the same error. The error occurs at the line in my code "Workbooks.Open filename("pickme")" and this happens when the loop reaches the blank (displayed, yet containing a formula) cell. So, it seems as though it...

Hello All Greetings Once Again, I'm working with a 'do while' to keep looping and applying a procedure code until a blank row is found. This usually works nicely for me. In this case, however, there's a formula in the row: IF(this, then this, otherwise " "). So there's a formula in the cell...

Hello All, As promised, here is my final successful code. The only tiny problem I am experiencing is that although I have the Do While loop specifying to stop at an empty cell, the cells actually contain formulae, so even when empty, this do while code doesn't seem to work at stopping the...

Had success going different route. I am heading out of office, but will post my solution for future reference and curious minds on Monday. Have a good weekend everybody Marie

Hi Again, Progress! (Some) I believe I have zeroed in on the problem: When one of the URL's is navigated to in Explorer, there is a short (perhaps 1 sec or less) delay the duration of which seems to vary (on the server's side) before open/save prompt comes up. I suspect that when the delay...