vba and macros

Hi there, I am trying the macros from the beginning of the book "VBA AND MACROS". When I tried to record the 2nd (Using relative references) and the 3rd (Not using AutoSum), the macros does not work, it load the invoice file but there is no formatting, and the "Design Mode" icon gets activated...

Ok so I have come to brick wall and don't know where to go from here. This is the first tab I'm working from:<TABLE style="WIDTH: 493pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=657 border=0 x:str><COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt...

I have several pivot charts and chart worksheets in my workbook. Additionally, I have several parameters setup where the data series will change based on the criteria selected. How do I create a macro, where no matter what the criteria is set that the color format for each specific data...

Hello all, I am struggling with how to insert the coding into an existing macro to loop it. I am not very experienced with VBA, the macro itself works great for the first row but I want it to do it for the entire range. I have a table of data, i want to copy data within certain cells on a row...

I am reaching here, hoping for a lifeline. Is it possible to use Excel 07 VBA to automate publishing to a website of a publisher document? -Thanks in advance! -Tex

Hi there everyone, I am new with excel and currently using excel 2003 and I have been asked by my manager to create an action item list and would appreciate anyones help! I've searched through the forums and I cannot find anything that will help me! What I need is a macro code/button that...

Could someone help me please. Below is an example entry in a single cell. I am parsing the different elements out into separate columns. 16 Aug Payment to xxx Type of payment yyy Amount £zzz<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The...

I am currently using excel to display some information. I was hoping someone can help me out with a Macro script. I am trying to create a macro that will check the current time. If the current time is greater than a time in a cell, then it should delete the row. Thanks for the help in advance

Hey Everyone, I have several rows of data. The last cell for each row (Column E) includes a checkbox. Once checked, the cell is marked complete. Is there a way to have that row transfer to Sheet 2 of the same workbook once the cell is marked complete? Thank you for any help.

Hello all, Fairly new to VBA, I have for example ( using "_" character to represent blank ) _ _ _ _ 2 5 3 9 0 _ _ _ _ What I want to do in VBA is return the range of the first row of only the cells that have data. In this example I would return the range of E1:I1 I've tried various...

I'm using Excel 2010 to pull data via a Worksheets ListObjects with an ODBC connection to a SQL Server. I haven't had problems with this till I ran into an empty record set. In the case of no records Excel continues to Refresh the external query and displays this in the bottom left corner of the...

Hi, I have a spread sheet that records when work comes in, this has a drop list in column H. This defaults to Work O/S and the user will choose 'Work Completed' when the have completed the work. I want to add a Macro to the list so that when the user chsnges the list to 'Work Completed' the...

Hi, I have created a userform and have set it up so the user will add the date by selecting the day on a listbox1, month listbox2 and year listbox3. This seems to work but I think it would look cleaner if I could set the user form to have todays date as default but if this date needs to be...

Two questions I first want to be able to copy that entire row that lookup value is associated in and copy where I currently have it going below. Second how do I input a cell 3 (col A) to the left of the copied cells which are in col D. The text that I want to be inputed is"ExtraActuals." Thanks...

I am newbie at vba and I am trying to get my vlookup using a macro to only return the NA# with the lookup value it used in another sheet. My goal then is too loop it so can do that through 1000's of rows. I first tried a "find" but my lookupvalues have //.. so "find" does not work but here is...

Here is my problem. I basically have 2 Columns. Column 1 has a list of numbers in sequential order and Column 2 has the formula =IF(A2=A1+1, "yes") I want to make a macro that will automatically extend that formula down as I add new rows in Column 1. I think this would require an Event Macro but...

Hi, I am looking to copy data from one worksheets to another. I will be filtering on column "U" using an array to show the 'to be filtered by' data. The code I have for this is: For d = 1 To 21 Worksheets("Raw Data wo ACT").Activate Range("U1").Select Selection.AutoFilter Field:=21...

I’m wondering if there is a way to use excel and or Microsoft word to accomplish a specific task. I have an excel file. Within that file I have two sheets. The first sheet consists of a blank form. It has blank fields for the employee, the hire date, and the employee number. The second...

Hi, I am trying to delete any duplicate row based on column "C" data. I have sorted the data so the data is sorted by "C" the account number and then "E" the date with the eldest first. When I run this code it does not pick up all the duplicates and does delete some that are not duplicates...

This is an Awesome Forum!! Just recorded my first macro. It works pretty good, but I there are some errors in it. Here's what I want it to do. 1. Unprotect the "Areas" sheet so the macro can run. 2. Delete all info in given ranges in the "Invoices" sheet. (See macro below for ranges) 3...