VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
11 views
VBA for Excel is running out of resources
I have an excel worksheet that I need to divide up into several smaller worksheets based upon the value of one column. The code works great, but runs out of resources when it gets past row 10k.
I ...
1
vote
2answers
18 views
Worksheet Activate Infinite Loop
VBA newbie here. I searched the responses, but I couldn't find anything useful. I have a chart in an Excel tab. I want the Y axis of the chart to dynamically update based on parameters I pass in, ...
0
votes
3answers
21 views
Excel macro for quit data cleaning
I was wondering if someone could assist me with suggestions on how to clean up data in an Excel spread sheet.
I have a very long list I need to go through. Currently, I am copying a list of data (to ...
0
votes
0answers
21 views
Modify Excel object edit in Word Document from another Excel document via VBA
I am trying to modify embedded excel object in Word from another Excel document with VBA. But I get one error about it. I have searched a lot, I have find some solutions which didnt resolve my ...
1
vote
3answers
14 views
Fill offset(0,-1) until particular value is matched in VBA
I am new in VBA and I am trying to solve one problem. I have Only Items column in Excel data like below. And I want to add code for each item which is in Code column.
Code Items
Animals:
AN ...
0
votes
2answers
27 views
VBA interpreter stops for apparently no reason
I am writting some function in Excel using VBA.
Here is my code :
Function PresentValue2()
Dim i As Double
i = 1
Dim coll As Collection
coll.add i
...
0
votes
0answers
21 views
Concatenate columns(user selected) and replace them with new column
I'm not an advanced VBA programmer. I'm working on an excel macro which will allow me to select a range(using input box) to clean the data(makes consistent with mySQL schema) on worksheet. I get this ...
0
votes
0answers
12 views
How to find whether attributes with specific values exist in the XML child elements?
I am trying to find out whether an XML Attribute with a specific value exists or not in each child element of the xml document root. My code is as follows:
Option Explicit
Dim sheet As Worksheet
Dim ...
0
votes
0answers
10 views
give data to the specific row according to the condition
I want a vba code like if in a row 3 value is abc and on the cells on (2,1) is correct or incorrect so take the value according to that row with correct or incorrect example
List item
...
1
vote
2answers
20 views
Comparing Columns and Highlight the Matching Data Using Excel VBA
I Need to compare Column B in Sheet 2 with Column C in Sheet 3 and highlight the cells with matching data in Column B (Sheet 2).
Have used the following formula in Conditional Formatting
which ...
-1
votes
1answer
13 views
Do something for each cell that is a formula and in column K or row 50?
I now do something for all formulas in a sheet with the code below. Can I add conditions so that I do the same thing for cells that match
formula AND (is in column K OR is in row 55)?
For Each ...
-2
votes
1answer
27 views
Copy worksheets to new workbook and prevent them changing
I have a VBA loop to generate a series of dashboards. It works by changing a two letter code in one particular cell, preforming a look-up, and allowing a set of charts to update on that worksheet. So ...
-1
votes
0answers
13 views
Change cell format to general using VBA
I've tried to set the formatting of a cell to general using:
Range("DR187").NumberFormat = "General"
But it doesn't work. Why?
Some clues might be that even if I right click on the cell and set ...
0
votes
2answers
33 views
VBA - Index / Match function with multiple criteria
I am facing an issue when trying to compile a multiple criteria Index/Match code in VBA. This might be simple - but i am fairly new to VBA and nothing i have found around here worked.
Example:
I have ...
0
votes
1answer
22 views
Compile error: invalid outside procedure
I m trying to make a excel vba based calculator witch post the out put result to a specific cell in excel sheet but when i am trying to call the user form an error occurred Compile error: invalid ...
