Search results for query: *

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...

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, I have a code that works 'some of the time'. Its purpose is to hyperlink to a set of URL's (listed in a column in Excel spreadsheet), which are addresses that automatically begin downloads when navigated to. Normally, once navigated to on the web, these sites present the surfer with...

I've written a macro to help generate a list of URLs (displayed one per cell in Excel). The number of URLs in the list and precise addresses will be different each time someone runs the macro depending on the input they give. When navigated to, these addresses lead to a prompt for opening or...

Hello, I would like to replace blank cells with the value "999" for all rows but only within a specific range of columns. Is it possible to do so using the following code: Sheets("Sheet1").Columns("H:K").SpecialCells(xlCellTypeBlanks).?????? ...and filling in something else for the question...

Hello, I would like to replace blank cells with the value "999" for all rows but only within a specific range of columns. Is it possible to do so using the following code: Sheets("Sheet1").Columns("H:K").SpecialCells(xlCellTypeBlanks).?????? ...and filling in something else for the question...

Hello, Could anyone offer suggestions: I have a list of URL addresses (the list will be constantly changing, but the format will be the same). When they are opened, I am prompted by Explorer to Save/Open, (I usually save the Zip file), and then prompted as to whether I'd like to Open/Open...