Recent content by jakefwilson

Thanks again Skip, the help is appreciated. I copied the snippet above verbatim (after changing "Address" to the actual value) and still got the same "run-time error '13': Type Mismatch". When I select "Debug" in the error messagebox, the following code is highlighted: If .Value = "" Then For...

Thanks Skip for your reply. I think I'm almost there... Once I've found the column in question, I need to be able to navigate through its cells as well as the cells in one of the columns next to it. I figured I would use ActiveCell offset logic in order to accomplish this. Here's a snippet...

Hi, I'm using a macro that includes the following code: Columns("K:K").Select This is fairly static, and unusable in worksheets in which the column I'm interested in is not "K". Is there any way to perform this selection via reference to the column label (my data has a header row)? By...