visual baisc

I am scraping an email for certain values that will return in my excel spreadsheet. If one of the values is hidden the next email that is scraped replaces the values in the hidden row instead of in the next blank row. Does anyone have any ideas on how to skip the hidden values and return the...

Please help me... Here's what I'm working on right now. Sheet #1 has: Company Code, Account Number, and Customer Name Sheet #2 has: Company Code, Account Number, and Customer Name Both sheets have the same data except that in Sheet #1 under the Company Code column the cells show "ABC", "DEF"...

I need excel to switch to Sheet2 whenever I double click in column one. Also I'm new to this, I already have a macro running for the A column that already activates whenever a cell in column A is activated. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

Here is a screenshot of my workbook. http://my.jetscreenshot.com/20092/20160209-nszp-274kb What I am doing now is a manual process. I am copying the above Highlighted rows and then "Inserting Copied rows" under each row that is labeled "original row" to generate the required data in rows...

In Excel VBA, how may I refer to already open page in Microsoft Internet Explorer?Something likeInternetExplorer.Application.Document.forms(1)I don't want to set application and navigate to specific website (automation of Internet Explorer from Excel VBA). The web page is already open in...

Hello, I'm an trying to figure out if this is possible, I believe it is. I have a form with attributes such as name, address, city.... and so on, that I want to fill out based on a data source with unique names and information. I want to input data on the data page and have the workbook pulled...