Search results for query: *

Hi there, I have been trying several methods of checking if a specific spreadsheet is open in excel before continuing to run. However, whichever one I choose, it continually returns false when it is in fact open, and then fails to close that spreadsheet and that instance of Excel. The...

Hi, Thanks for the above - have just found out that my pc had no reference to the Microsoft DAO 3.6 (couldn't tick it - as per above). Have just located it via the browse option and copying from someone elses machine, and is now working. Thanks Victoria

Hi, I have been trying now for several hours to open and update a recordset. I seem to be having trouble compiling the project and running it (or even F8'ing it!) Basically all posts I have read, both hear and on the ms forums say I need to have the Microsoft DAO 3.6 ref selected in...

Geoff, At the end of the Function values are as follows: lRangeStart = 27, lRow = 47, and lRangeEnd = 21. V

I've F8'd through the code which is how i know that it does search through the missing range correctly (i.e. If Len(Cells(lRow, lCol)) > 1 Then bEmpty = False lCol = 14) - it just seems to forget to add them to the final array at the end. will keep trying it - to be honest there are a few...

Here is the function where it loops through each row and column. On this occasion it returned an sRange of A11:N13,A15:N16,A20:N21. However it also looped through - correctly - the range A27:N46, but then didn't concatenate it at the end when combining the range. Please let me know if you...

Hi there, I am currently attempting to decipher a rather large macro that was written some time ago, which also has hardly any annotation and no documentation. I think I have located one of the problems with it (well maybe?! as i think there are several.) Basically the macro loops through a...