Recent content by KHMcKenna

I have found that some of the disk cloning tools will actually toggle the "Active Drive" setting on a HD. We've cured this by using a compatible FDISK type utility to reset the "Active Drive" parameter. There must be some type of conflict with 2 drives being shown as an...

The end functionality that I am needing is to test the external books' cell (actually identified as a single cell RANGE for ease of locating the information [its actually DATE oriented naming]) for a non-null value. So, a typical application in this scenario might look like...

.... Is there any way to access the "VALUE" of the EXTERNAL cell, other than making a local value of it? (RE: "Sheets(2).Cells(1, 1).Value = sReference" ) ??? The reason I ask, is I will have a few dozen references to this function, all requesting their unique values...

I'm hacking around on this to get it to work for my specific application... In my efforts prior to posting here, I had gotten everything to work ALMOST to my satisfaction with the exception that the cell values were showing the PATH to the value I was wanting, and not the VALUE.... It's looking...

OK.. I see lots of problems with my proposed post. (blush) I'm glad not many people read these posts! (wink). (the smoldering smell continues)

OK... I've been reading and RE-READING this... One question that comes to me as I try to come to grips of the mechanics involved here is... Would this convertible to a FUNCTION?? With me not quite up to speed as to what is exactly happening here yet, my arms lenght question is, could it look...

Thanks Skip... This VB newbie is attempting to digest what you sent, and how to apply it to my scenario.... (enter here, the scent of a smoldering brain) I'll be back in a while.. (hopefully) Kevin

I need some help on how to create an Excel function that will allow me to check for the value of a Dynamically determined NameRange (Day1, Day2.. etc...) on a CLOSED workbook/worksheet. I have found how to create such a function (via search engine(s)), but its only accessible via VBA calls, and...

I very much need help, any input would be greatly appreciated. I need to be able to find out if an Excel user has entered a value into a particular cell/rangename. The cell/rangename will not be static, so I need to be able to dynamically query anywhere in the sheet (based on established range...