Tagged Questions

0
votes
2answers
17 views

Macro Select all for Pivot tables

I am trying to make a macro for creating a pivot table. I need the Macro to select all of the data on the sheet; a friend of mine has helped me create the code above, however the macro only selects ...
1
vote
1answer
16 views

VBA Delete Empty Cells with Multiple Column Selection

I am having a small amount of trouble with finding a possible solution to a potential problem of mine. I am writing a macro for my supervisor using VBA so that she can just click a button assigned to ...
0
votes
2answers
17 views

Macros: Recorded Macro not working

I have recorded a macro in excel using Record Macro option. However, when I run it, I get the Error 438 and the error box displays Object does not support property or method. Here is the generated ...
0
votes
0answers
21 views

VBA Chart From Pivot Table

Dear Fine People of Stack, I have previously asked for help from the community and the community came through. In the span of a few moments I learned more at one time than I have in my classroom all ...
0
votes
0answers
23 views

Excel Macro Issue, Data Column Separation

I am having an issue with the format of data in excel coming from another system. The data does not separate into columns but rather becomes indented in a single column. See example below. Country ...
0
votes
1answer
44 views

Excel Macro Button not displaying correct data

I have one button macro for reading data from excel files after leaving some(irrelevent starting rows of detail) rows(A1-A10) and merging all those files in single file. It runs correctly when i use ...
0
votes
2answers
44 views

Macro 101: Beginner advise [on hold]

Where can I find basic terminology on macros, and basic formulas? Without buying a book? I have been looking online a lot and I cant find a macro dictionary or anything of the sort. basic stuff like ...
0
votes
2answers
54 views

Excel 2010 vba copy select sheets, save and close both workbooks

I have a workbook that creates 3 logs. Before close I need those three sheets to copy into a new workbook then I need both workbooks to save and close themselves. I've gotten as far as the code below ...
2
votes
2answers
32 views

Referring to newly added worksheets

I want to refer to newly added sheets. They are added by a loop. They are named Sheet1, Sheet2, Sheet3 etc. I also have a variable n which equals to 1 when a Sheet1 is created, equals to 2 when a ...
0
votes
1answer
33 views

running macros to a protected sheet - no other answers found

Here goes... I have created a project form consisting of 31 Worksheets in the 1 Workbook. Worksheet 1, called "NOV Summary", is a summary page. The other 30 worksheets all have various details ...
1
vote
1answer
28 views

Open Work book does not close after running macro

I have a workbook sheet which runs a macro from another workbook. The functions run fine. But the workbook having the macro (which is run from the active sheet) gets open and does not close through ...
-1
votes
0answers
23 views

macro to Concatenate cell values and paste at the end

I am new to excel macros. Please help in creating a macro as per below requirement. Requirement: to concatenate values at then end of each row in table with colmumn headername and char ":" and ...
-1
votes
1answer
49 views

Microsoft Excel: Split text in cells at line breaks

I am working on an excel spreadsheet that has data in 39 columns. One of these columns, column AJ, is a description field, and contains text describing the row item in detail. This text inside the ...
0
votes
1answer
40 views

Using loops to multiply values from different sheets in Excel [on hold]

I am looking for a code (Macro) that multiplies values from four sheets to calculate the demand of XYZ product the next day. Sheet One contains: 10 Rows and 2 Columns = 10 X 2 it also contains a ...
0
votes
1answer
34 views

Excel Macro Explanation

What does this macro code does ? Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(3, 1), Array(14, 1), Array(15, 1), Array(17, 1), ...
1
vote
3answers
38 views

Remove Workbook_Open Code In the copy saved with Save As from VBA

I'm trying to force the user to save the newly filled template (created with VBA and the macros inside it) to avoid data loss when it reopens (so users don't have to delete the data after creating ...
-1
votes
1answer
15 views

Consolidating Data from 5 worksheets to 1 worksheet based on certain conditions [on hold]

I have a workbook with 5 sheets. It is for tracking applicant for job positions. I can upload it if need be as I have a copy with certain proprietary info blacked out. I have 5 sheets, the first ...
0
votes
0answers
36 views

Run excel macro using vbscript

I have an excel sheet "project.xlsm" with a macro that updates a cell value. I want to run the macro using vbscript externally. The important thing is I don't want the vbscript to open the workbook or ...
1
vote
1answer
39 views

Macro causing unreadable error

When I open an Excel 2007 workbook with macros, I get the following error: Excel found unreadable content in {FILENAME}. Do you want to recover the contents of this workbook? I wonder if it ...
0
votes
2answers
28 views

Code not recognizing unique values in excel

I am working on a code in excel that uses a unique number and associated date to see if a same record already exists in the worksheet. Here is my code: Part of first code... Else 'If all the ...
1
vote
1answer
19 views

For without Next Error on Email Macro

Hello I have this code here returning an error "For without Next" and it highlights the end sub all the way at the bottom. Why is this happening? I'm just trying to insert the value of certain cells ...
0
votes
1answer
24 views

Select a range of cells between rows with designated values

I am trying to format a large text file in Excel. It looks similar to this to begin with: Headings ---------- Data Data Data ENDROW Other Information I want to select the cells ...
0
votes
0answers
56 views

Put cells in ComboBox. When cell selected, copy cell collumn to new sheet

I'm trying to create a macro that when finished, should load the contents of some cells (on sheet "1. Process information") onto a ComboBox (on sheet "shipsheet"). Once something is chosen in the ...
0
votes
1answer
23 views

Compare without order and neglect comma in excel vba macro

I want to compare two columns with names, but they are in different format, for example, one is Xu, Boxi; the other is BOXI XU. So I need to compare it neglecting order and comma and not case ...
2
votes
2answers
54 views

Do Microsoft plan to make VB.net standard as the default macro language in Excel? [closed]

Currently VBA is the standard macro language. When I record a macro VBA is generated. I am new to the language however I would rather learn to use VB.net than VBA. Maybe this is unjustified but I feel ...
0
votes
1answer
22 views

VBA (Excel): Jump to (or remain) cell in column

I would like to start off with stating that I have virtually no coding experience. I found a VBA snippet online for highlighting an entire selected range (just to as a visual guide): Private Sub ...
0
votes
2answers
53 views

Get data from excel worksheet and copy it into the active workbook

I'm new to using VBA and have found the code below. It works fine but I need all the rows in the source file. How can I change the code so I'm not limited to using the row numbers as the will be ...
0
votes
2answers
27 views

Checking Values in Cells

I made a Sub. But its giving an error.! I want to check if column A has values then it checks for columns" H and I ". those must be filled. Else the file wont save..!! Private Sub ...
0
votes
1answer
61 views

Insterting a new Row and Copy the data from a cell to it using Commands/code in excel

i never programed an excel macro using vba and i heard it can do nice things, and i'm facing a problem i hope excel macro can solve me it, because i have huge amounts of data that need filtering its ...
0
votes
2answers
47 views

Macro to replace text if value is less than 1 character - Excel Macro

I have found a macro perfect for my use on here, so thank you already stackoverflow community! I'm just struggling to amend the end last part of the below: Sub Forename() ' Macro to delete rows if ...
0
votes
1answer
44 views

EXCEL - Macro to conditionally merge rows based on cell value

I'm after a VBA macro that will merge the content of the current row with that of the previous row if the content of Col C for the current row is empty Input Col A | Col B | Col C text1A | ...
1
vote
0answers
24 views

Macro to insert rows causes #VALUE in formulas

When I run a macro to insert rows for a subtotal one formula returns a #VALUE error. If I do it manually no error is produced?? =IF(CELLHASFORMULA(V3),V3*E3,V3*0.745)*.45+V3 is my formula in one ...
0
votes
1answer
26 views

How to identify the clicked shape name in VBA

I am trying to create an excel template where I have already assigned different macros to different shape that act as buttons. Now I am having problem of locating which one I have clicked since I need ...
2
votes
1answer
63 views

Performing SQL queries on an Excel Table within a Workbook with VBA Macro

I am trying to make an excel macro that will give me the following function in Excel: =SQL("SELECT heading_1 FROM Table1 WHERE heading_2='foo'") Allowing me to search (and maybe even insert) data ...
0
votes
2answers
65 views

Excel macro to sort cells in rows by length

A couple years ago, by browsing different forums I made myself a macro that was sorting columns by length, longest to shortest (by number of characters in cells). I was pasting special with transpose ...
0
votes
1answer
52 views

VBA Excel - Workbook_SheetChange

Hopefully this question hasn't already been asked, I tried searching for an answer and couldn't find anything. This is probably a simple question, but I am writing my first macro in excel and am ...
0
votes
3answers
84 views

Excel 2010 VBA macro adjust to do all rows 1-by-1 down to the last row (14000 rows)

Right now the macro does the following: 1. Selects entire row. 2. Sorts sideways (left to right). 3. Goes to the next row. (And is ready for me to do Ctrl+s and make it run again on the next row. ...
0
votes
1answer
59 views

VBA to copy chart line color to many charts in different worksheets

At work I have 72 Excel 2010 workbooks in total, each with 12 sheets, with a chart on each sheet (I think this means the charts are not embedded?). I am a basic programmer having only covered VB at ...
2
votes
2answers
83 views

Trying to extract data from website into Excel. For loop not working

I am trying to extract data about NFL recruits from the following website: http://espn.go.com/college-sports/football/recruiting/rankings/_/class/2013 I need to access every single position and ...
1
vote
3answers
38 views

Using the object of a `With` statement as parameter for a procedure call

Is it possible to use the object of a With statement as parameter for a procedure called from within a With block, without having to fully qualify that object? It could be the equivalent of a this or ...
0
votes
2answers
57 views

Worksheet_Change Macro - Changing multiple cells

I wrote a macro and while it works, functionally its not what is needed. It's an interactive checklist that breaks down multiple areas of machines and if they are working checks them off and then this ...
0
votes
0answers
38 views

Excel using VB (macro)

Errors I cant find solution and when I run it says: Run-Time error '9'`: subscript out of range Function Make_Active_Worksheet(name As String) As Worksheet **Error** (Windows(name).Activate) Set ...
5
votes
1answer
178 views

Bypass password on an Excel VBA project *.xla

Due to a change in procedure I need to update the code in an excel macro. The person that designed it has left the firm two years ago. While trying to revive it, I found out the macro project is ...
1
vote
1answer
20 views

SpecialCells causing SheetSelectionChange event in Excel 2010

I have a test Macro Sub test() Dim rSrcMatrix As Range Set rSrcMatrix = Sheets("Code Matrix").Range("Xfer_To_Xfer_Matrix").Range("A1") Set rSrcMatrix = ...
0
votes
2answers
143 views

Excel macro loop through rows and copy to another sheet

I'm new to VBA and trying to acheive this in Excel: I have a sheet1 where there are rows with values. I have created a button which executes and copy the first row of data to another sheet(Sheet2), ...
-1
votes
0answers
40 views

Match key word from one column and show the results in another column in excel using macro

Thanks for reading my problem. I have one huge excel sheet containing two column named "testname" and "results" in sheet 1. Column 1 contains the definition of several test cases and Column2 is ...
0
votes
2answers
36 views

looping over rows and copy values into an external file (sheets indexed by cell values)

I am a newbie of VBA, so sorry for the basic question. I need to create a loop where at each iteration the script: copies O6:AA6 of Wb1 into O1:AA1 of the same Workbook copies the columns B:E into ...
0
votes
2answers
48 views

Excel VBA Macro Graphing Dynamically

I have an excel file that opens automatically then it runs a macro. This macro imports data from a txt file. Every 1 hour, data goes into the txt file into a new row (time stamp and a value). My macro ...
0
votes
0answers
52 views

Use solidworks macro to insert parts into assembly based on excel file

I am writing a macro that will eventually (hopefully!) read part numbers from an excel or text file, then search through the config's of my parts library and insert the corresponding components into ...
0
votes
2answers
125 views

How to autofill formulas VBA

I am trying ot make a macro that will copy ranges from other reports and put them into one big report. The range copying works fine and does exactly waht it is supposed to. The issue I am having now ...

1 2 3 4 5 … 24
15 30 50 per page