vba 2007

This code is looping through a range and looking for any cells that contain hyperlinks and then doing some other stuff. I keep getting the error "Next without For" when running my loop. You'd think this would be an easy error to find. Near the bottom of the code where is reads "Next...

I want to add a print command for cells in a range that contain values other than </SPAN> <TBODY> #DIV/0!</SPAN> </TBODY> The column range is a-h and the header is in row one which I would like to repeat. Another option is to auto format the print field. Any suggestions? Thanks</SPAN>

Hello I am running a macro that takes a weeks worth of noise level data and pastes them into other spreadsheets to then array specific periods of time. The code I am running is clunky and takes a long time to run because I have been searching each row, then copy and paste into the new...

Hello I have a list box (Listbox2) that I would like to hide a row on a different sheet based on the selections made. I have tried a number of codes and the closest I can get is to hide all of the rows regardless of the selection. List box references: "a","b","c" Rows to be hidden: "a" -...

I wish to create a macro that looks in a specific directory "D:Records" It finds the files which are modified after a date "January 01, 2012" in this directory (pdf files) Then it imports these files names into a worksheet Is this possible please??? Please Help...

Hi everyone, I am far from being an expert at Excel so the more layman the conversation, the better. I have a table that contains 7 columns, with each column representing an attribute of a product. The number of data or rows for each column is different. To be more specific, the first column is...

Hello, I have just created with VBA a new Excel file (A) that I will develop further (i.e. run more VBA on it). I also have a source Excel file (B) in which I have source data to run VBA scripts. So it is important to specify from which of both Excel files I read data (A or B) or write in...

Hi, The content of excel is captured as an image with the help on macro. Now i want to create one more macro that will send an email with the captured image as body of the email. (Note: the image should be in body and not an attachment.) Is there a predefined method in VBA? Thanks! Archie

Hi, I have written a code for reading the excel and capturing the content as an image but now i want to paste the captured content into another sheet of the same excel and want to add new column in the same captured image? Can you please let me know if it is possible to add a column in the...

Hi,I want to write a VBA code that will find the third monday every month and will add one sheet in my excel.I have a code that adds a sheet to excel but not able to apply the logic of third monday.For eg: if i run my macro on 20th august. i will check if its 3rd monday and will add one excel...

Hi, I have a userform with 2 text boxes for users to complete. one should contain a numerical value, the other should contain the user's initials. Is there a way to limit the entry to the text boxes so that it will only accept numbers for the numerical entry and only accept letters for the entry...

Excel 2007 Windows XP Hello I need to populate a table with two formulas. The numbers of rows and number of column will vary. I've got my code up to the point where the table is outlined: <tbody> Employee Name Job Title 7/22/12 7/23/12 7/24/12 Employee1 Employee2 Employee3...

Hello, I am trying to put together a standalone VBA macro that can easily be inserted into my financial models that allows me to quickly switch between two different printing setups – e.g. 8.5x 11 and 11x17 tabloid. I hope that was clear enough to understand. I have never used VBA or coding...

Hi All, I need help for the below activity. I am not well versed in Macros. Below is the scenario. 1. I have one Workbook, with two Worksheets named as; "People" & "Masterfile" In People Worksheet the Data is as below: <tbody> Column A Column B Column C Column D Column E...

I'm running Excel 2007 I have three related questions here. I have a concatenate: CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)) that yields a result like: $C$927:$F$1742 but...

Hello, I have about 4 steps to execute with Excel files and I have 4 separate vba macros created for this. I'm wondering if I can create a vba macro that would execute those 4 macros consecutively? Thank you for your advice.

Hello, I have been looking on internet for a solution to this common error message, but have not found it. I open a file, and in the code activate that file before closing it. I give you the code below with the line where I get the error message. Select Case nStage...

I have an Access 2007 specifically for report-building using link tables. There's very little data in local tables, except for small tables used to filter reports, populate list boxes, etc. Right now, I'm trying to make a local copy of this db, including the reports, queries, forms, etc. from...

Hello, I would like to select data from 2 different columns in Excel, depending on the column selection in a drop down list (e.g. column A or B) defined in another named cell (e.g. Listcell). So I select the column from that list and then will make calculations on the chosen column. Can you...

Please can any one help, I have created a Radar Graph uisng the following criteria <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=255><COLGROUP><COL style="WIDTH: 109pt" width=145><COL style="WIDTH: 83pt; mso-width-source: userset...