Macros Related Problems & Solutions

170 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 170
[Solved] auto populate text from data validation list
Summary: Hi, I want to auto populate my data in column H. It's a vlookup in macro. I have a data validation list in Column G from row 12 to 100 and I want to a...

[Solved] Swapping adjacent rows (moving a row above the row above it)
Summary: What if I wanted to swap adjacent rows without entering the row numbers I wanted to swap? I'm trying to write a macro that takes the currently selecte...

[Solved] How to write Macro to add additional rows with existing form
Summary: I have a multi-tab workbook and am trying to solve 2 issues with 1 macro. BACKGROUND The workbook contains a main tab with all of the 'entered info' t...

[Solved] How to Calculate next 20 or 40 Business days.
Summary: Hi .. It is like if I enter today's date in the specified row and next row next 10 working days than I should able to get the exact date (after exclud...

[Solved] How to have a new row automatically appear after data input
Summary: I'd like to have a macro where every time cels A2:F2 have data inputted into them it automatically creates a new, empty row 2 and shifts all of the da...

How to move a row when a particular cells status changes
Summary: I am needing to create a macro that will perform the following actions: Ex. I have a sheet that has the following values selected from a data validati...

[Solved] VBA to Check if Cell is True before Proceeding
Summary: Hi, I have a macro that you choose a workbook and it copies the data in to a master worksheet. I have now been asked to check a cell in the workbook ...

[Solved] How to change a lot of cells to absolute (macro fails?)
Summary: Hello all Ive been using this macro a lot of times, but I am running into some strange problems with it. Sub Absolute() Dim Cell As Range For Each C...

[Solved] I wish to return row/column references from Excel data
Summary: How do I... Have an Excel table with dates in A (col 1) and financial data in column G (col 7). I wish to enter 2 dates into a macro and from these fi...

[Solved] automatically enable macros on excel spreadsheet start
Summary: Spreadsheet contains macros. On startup of any spreadsheet the macros are disabled. To activate macros need to select option before proceeding. I thou...

[Solved] Mac Excel, multi worksheet file, tab name is running numbers
Summary: I desperately need a macro to show sheet(tab) name in a fixed cell(e.g. J8) at the same sheet, and copy most left sheet to left side with auto rename ...

[Solved] Relocate specific rows within the same worksheet
Summary: I need a macro that will find rows that column K shows "X", then cut the rows and insert them further down the same worksheet below a merged row highl...

[Solved] VBA Macro Fails to Run - Error 52 Bad File name?
Summary: I am trying to create a macro to combine a number or powerpoint presentations into one to enable me to print a handout more simply. Here is the script...

[Solved] How to run a macro automatically
Summary: I have a macro in my spread sheet which returns a value in cell G154 and would like the macro to run automatically if a value of 13 is returned in cel...

[Solved] how to find values in range of cells and display message
Summary: Using a macro, in cell range D2:D151, find values between 0 and 8 and if true display a message in cell F151 "No Jackpot this week". Can you help ? ...

[Solved] Excel Macro to color certain words in a line of text
Summary: I have a list of banned words which I have named "content_check" and are in a tab called "Guide". I want to make a macro which will check cells G13, G...

Use of Macro's in OpenOffice.
Summary: What language do they need to be written in? Apparently Macro's from Excel in VBA will not wor#k in OpenOffice. ...

Changing color of cells based on color of other cells
Summary: Hello, I have Windows XP, and I need help with a macro to do the following without changing the content of any cell.... Cells C3 - P3 are conditionall...

[Solved] How to find the same numbers in Excel 2010
Summary: I have two columns of ID numbers, A1:750 and B1:750. In each columns there are some IDs that are the same but also some IDs that are different. When a...

how to Save As Pdf & Name From Cell with macro code
Summary: Sub Macro7() ' ' Macro7 Macro ' ' Sheets("Form 16").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Raj...

[Solved] How to code a specific mathematical operation in VBA
Summary: I am submitting a Macro that does not work like I need. If Target.Address = "$B$1" Then 'disable events Application.EnableEvents = False '...

[Solved] How do I make conditional formatting with Macro for the row?
Summary: Hi. I am looking for a way in Excel to conditional formatting with a Macro for a row and the one above it depends on the value in last cell of row. Me...

[Solved] Run Time Error '1004': Select Method of Worksheet Failed
Summary: Run Time Error '1004': Select Method of Worksheet Failed This comes up after selecting an entire row and running a macro from ctrl+m which is suppose ...

[Solved] Macro formula to insert lines depending on quantity field
Summary: Hello, If the quantity in Column G is >1 then I need to insert the same line one less times than the original quantity. In the example below in cell 2...

[Solved] Macro to insert rows based on input
Summary: I am trying to figure out a way to insert multiple rows, based on the input value in column E. For example, if the value in B5 is 5, I want 5 rows ins...

[Solved] Recording macro in excel 2007
Summary: I am having a problem I cannot resolve when recording macro in Excel 2007. I am trying to record macro in a file which has the following: 1. Sheet one...

[Solved] automatically capitalizing 1st letter
Summary: With the use of the macro: Private Sub Worksheet_Change(ByVal Target As Range) Target = Application.WorksheetFunction.Proper(Target) End Sub How can ...

[Solved] How do I use a macro to change to color of the cell?
Summary: I know very little about macros, so i really need some help. I am tryinng to create a macro that will change the cell color (not the font, the actual ...

[Solved] Macro to Add rows based on the infrmation in another cell
Summary: I need a macro which should add below each row the quantity of rows shown in the column named "TO-FROM". Then, the same information of the original ro...

[Solved] Need Macro to insert and copy lines but change two values
Summary: Hello, Wondering if someone could help me modify a macro to include a couple extra steps. I found code on this website that: 1. Inserts rows based ...

123456

Popular Tags


Ask Question