Home

Macros and VBA

103 Conversations

Latest Activity

Custom List Message Item

Hello,

 

I recorded a Macros on one tab to create 6 charts from data available on that sheet, but when I added the macros to the next sheet, it fails and gives me the below message

 

Failed Macros.png

 

Any help would be greatly appreciated. Thanks!

Read More
39 Views
2 Replies
If you click OK on that dialog, which line turns blue?

I  need to autofilter based on a cell value in A1 of Sheet2. Which is called Teams Results i am guessing it goes where the "*" is but i cant get anything to work.

I have so far got this:

 

Sub MoveData()
Sheet2.[C7:AC209].ClearContents
Sheet26.[C7:AC209].

... Read More
24 Views
0 Reply

Hi Guys,

 

I am having trouble trying to record time stamp of active cells which has IF function. For example if I manually change a cell, then this gets recorded in the logsheet with time stamp and value.

 

But active cells with IF function, for example

... Read More
11 Views
0 Reply

Hello friends,

I'm pretty new to the macros but as i have started working in excel my job is getting difficult as i go through the data. i need to delete rows which only have date and time in the first column and the rest columns have other data, now the p

... Read More
66 Views
2 Replies

Hi Aditya,

 

please find attached my solution using VBA. The macro text is:

 

Sub ConditionallyDeleteRows()

    Dim vaData As Variant
    Dim rData As Range
    Dim r As Long, c

... Read More

Hello ,

i am trying to connect oracle database but here i am facing issue to choose Driver(provider) which i have to use here .i have selected "microsoft activex data object 2.5 library" .My machine is 64 bit widow 10 with office 2016 . can anyone please

... Read More
24 Views
0 Reply

 

Hi,

I am trying to rearrange the excel structure.

I want to make store 1,2,3,4,5,6,7 as column and put all price under the column.

So I want to make first picture like second picture.

 

Is there any macro that I can use?

 

Below is where I am now.

BEFORE.jpg

 

 

Below is the

... Read More
69 Views
1 Reply
Hi Hyejin, I think I can help you with the file, no Macro is needed. Could you send me some example of original file in Excel format and the result file ?

Best regards
Zvon... Read More
If Range("matrixtable[@endoftcLE]").Interior.ColorIndex <> 36 Then _
  Range("matrixtable[@endoftcLE]") = Application.VLookup(sDetailLeft, sectiondata, Application.Match("endoftc", sectionheaders, 0), False)

The statement generates the error "Method 'Range

... Read More
25 Views
0 Reply

I have an Excel workbook that automatically opens a dialog box to select which sheet(s) to view. Since the latest update (11/14/2017), the dialog box no longer opens on start. I've set the Macro Security Setting to "Enable all macros ...", but still no di

... Read More
62 Views
5 Replies
Can you run macros from the macros list (alt+F8)?

Hello Everybody,

I need some help to create a macro on Excel VBA.
I've got a table in which the column n°3 contain some informations coming from a list.
I want that if this column contain the word "Engineering" by exemple, this select the entire row and copy

... Read More
18 Views
0 Reply

Hi,

 

I've quite new in using macro and have only  learned via blogs/youtube.

 

I've been using this macro to consolidate my data from different workbooks into one. However, if a cell is hidden, the hidden cells are not considered in the count of cells to be

... Read More
47 Views
1 Reply

Hi

 

I'd recommend you take a look at Power Query for consolidating data from files

(assuming you have Excel 2010 or later)

 

I used to use VBA to do what you are doing but no

... Read More

Hello.

Today one of my odbc tables finished working, used it every day before. It stops excel every time, details below:

Problem signature:
  Problem Event Name:                        APPCRASH
  Application Name:                             EXCEL.EXE
  Applic

... Read More
37 Views
0 Reply

i have a column of numbers that are color coded (to represent a specific mfg department) and I need to total the values by color.  Meaning I need to total all the values that have the same background color.  

 

I have done an exhaustive search online and wa

... Read More
1,829 Views
11 Replies

Hello,

 

take a look at this question in the Microsoft Community formerly known as the "Answers" Q&A forum. (I know, the "Community" site name is confusing to have on two d

... Read More

Hi matt nipper,

 

since you mention that you "have done an exhaustive search online" i have come up with a solution for you, although it has a rule that it will only work,

... Read More

@Mourad Louha's suggestion of an extra helper column for a sumif is by far the safest and most easily understood option.     

Read More

Hi Matt,

 

may be using the SUMIF or SUMIFS functions could help. You can define as criteria the same criteria you defined for the conditional formats. And, you don't need

... Read More

Hi my name is tony ,i was working on a sheet that allows me to send email directly from it.

Everything works great but there is one problem.
Once VB saves the file with this code

    'Save curent file to desktop for attachment.
    Application.DisplayAlerts 
... Read More
23 Views
0 Reply
Whenever I try to add solver to excel, excel stops working and shuts off. Once it closes, I try to open it up again and it says to disable solver add-in because it is having trouble working with solver. I need solver for my class. Can you please help me? ... Read More
35 Views
0 Reply

Hi,

I'm using a new PC running Win 10 64bit and MS Office Professional Plus 2016 (Excel 32bit).

 

I've copied the PERSONAL.XLSB file from old PC to new into the XLSTART folder accordingly.

 

Starting Excel after fresh restart of the PC, it opens the PERSONAL.X

... Read More
36 Views
0 Reply

Hi,

 

I'm trying to add a step to a macro that I use to clean up data before importing it into a database.  I want the macro to select all the data in the open worksheet, then sort it by the first column (header row name is ID) because the data I receive is

... Read More
65 Views
3 Replies

This should work:

Sub Step4()
    Dim rngToSort As Range
    
    'Set variable to currentregion starting form cell A1 on worksheet Sheet1:
    Set rngToSort = Worksheets(
... Read More
Best Response confirmed by sr misericordia radel osb (New Contributor)

Hi All,  who is online now, I need urgent support in creating macros 

44 Views
2 Replies
We support you creating macros! For anything else, please be more specific.
We're not here to build your application for you, but if you ask specific questions you are more likely to get some help :-)

I'm using Excel version 15.38 for Mac and I'm getting a runtime error that I don't know how to fix it. This macro worked perfectly for months, I stopped using this spreadsheet over the summer, and today when I go to use it again, it mysteriously won't wor

... Read More
186 Views
9 Replies

That code will definitely fail. You're using the Selection object to find something after the ActiveCell. If nothing is found, an error is thrown. Overall it's very messy

... Read More

I am managing an advertising campaign in various platforms: Adwords, Facebook and more.

 

I use an excel file to overlook all the statistics from those platforms,
so i have to fill the data manually every day.

Can i set a code/ function that can pull automati

... Read More
32 Views
0 Reply

I have built a model in Excel 2007 and included 3 cut ‘n paste macros (recorded – not written). I have sent it to my friend (I don’t know what version of Excel he has). When he runs (at least one of) the macros a message comes up headed ‘Create Table’ ask

... Read More
52 Views
5 Replies
Can you post your macro please?

Do I need a macro to achieve this graph ?Screenshot.png

Read More
21 Views
0 Reply

When I try to active the solver add-in, I get a error message telling me that it's impossible to execute it. What can I do?

31 Views
1 Reply
I think you might need to repair your Office installation. Control Panel, Software, find Microsoft Office and click the repair button.

I've been trying to get a simple macro to update charts and tables in powerpoint from data in excel (the actual spreadsheet is much bigger - I've created a simple version here).  This program works perfectly fine on the Windows version of Excel and Powerp

... Read More
45 Views
0 Reply

I have never used macros before and I'm not sure if they can accomplish what I would like them too. I have a very large spreadsheet that I am trying to get information out of. Right now I custom filter a column to narrow down the data to a specific range

... Read More
41 Views
1 Reply
I would start by recording a macro as you do it one time. Then open the VBA Editor and study the recorded code. Perhaps you can modify it to your needs for the remaining ... Read More

Hi,

 

my workbooks suddenly stopped working after an Windows/Excel update.

I used Excel VBA to read the file properties of files in a folder, without opening them.

Now the same code is just returning the basic properties, like title, dates, etc.

What I need is

... Read More
125 Views
2 Replies

Hi,

 

I am seeing the same problem with all but the initial properties (circa 6) returning as blank.

It appears very machine build specific as the code is running on some ma

... Read More