VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
4 views
vba macro which search particular text in a given column
I have a workbook which has the following sheets.
Search
Recommendations - Raw data
Findings - Raw data
Findings – Result
Recommendations – Result
I am trying to search particular text in the ...
0
votes
0answers
8 views
VBA Excel Function Error Runtimeerror 13
I cannot find the mistake. The error msg gives me "runtime error '13'" data types don't match. The error seems to be in the function "fillcalweeks".
Fillcalweeks should return an array which is ...
-1
votes
0answers
9 views
ms excel compare text
I have 3 columns in excel, which contains text. I want to ask for a formula that can solve my problem. the situation is like this
a b c (result)
n n c
n c c
c c c
c p p
...
2
votes
0answers
12 views
VBA:Editor. How to collapse worksheets by default
I work with several workbooks containing 10-15 Worksheets and several modules.
Whenever I open the VBA-Editor, or bring it back into focus, the project explorer has expanded the "Microsoft Excel ...
0
votes
0answers
11 views
Put unique distinct values into a list from multiple columns of an array
I'm new to Excel and the journey has been good so far, but I haven't been able to resolve this particular issue by myself. I'm dealing with a table as under:
Essentially, I'm looking to refer to ...
0
votes
1answer
20 views
How to group the rows in excel using macros
This is what i need
i want to group the rows of above screen shot to below screen shot
Tried a lot using macro but not getting proper any one please help me out
Thanks in advance.
4
votes
0answers
15 views
SAP: SAPGUI Parse GuiUserArea
Problem!
Currently at the place that I work We are trying to perform some kind of repetitive task via automatically with the usage of SAPGui, Excel & VBA. Usually, the most of the reports that ...
0
votes
1answer
16 views
PivotChart: Can't move title without activating the chart
I am writing a little macro in Excel 2010 to move the chart title of a pivot chart, and I can get it to work using a method that activates the chart and selects the chart's title. Here is that code
...
0
votes
2answers
41 views
How to transpose multiple columns into a single column?
In quantity, how can I transpose this format:
a a1
b b1
c c1
d d1
e e1
into a single column as below?
a
a1
b
b1
c
c1
d
d1
0
votes
1answer
12 views
Global variable useage in Windows( ).Activate
I have set some Global variables and they are working, without the GV I have Windows("LimeSurveyTokenTable.csv").Activate and this is working.
I need Windows("LimeSurveyTokenTable_ & strA & ...
0
votes
2answers
22 views
Assigning and manipulating values in a Date array
So I am trying to use a date array but have come across a lot of trouble with it. i've tried just about everything I can think of but can't get it to work.
Essentially what the problem is, is that I ...
0
votes
2answers
34 views
HowTo show values of cells in array
I have tried reaseaching with Google-Fu but was not able to make this work:
Sub LoopRange()
Dim rCell As Range
Dim rRng As Range
Set rRng = Sheet1.Range("A1:A6")
For Each rCell In rRng.Rows
...
0
votes
1answer
15 views
Save A Worksheet as A PDF
I am having an issue with saving multiple worksheets as a pdf. I have looked on this website (and others) and found similar code to what I have been using. However, the code that I have modified to ...
-2
votes
0answers
30 views
My IF statement does not recognise a counter
I have a simple if statement, that should test the value of a counter called ROW_NO. If ROW_NO > 0, ROW_NO must increase by 1, else it must be set to 7. At the end of the routing, I display the ...
0
votes
0answers
14 views
Excel 2010 .SetSourceData vba chart
Good morning,
I'm having a problem with selecting ranges for .SetSourceData for my stacked bar chart.
My ranges are noncontiguous. The start date is in column G, and the rest of the numbers are ...
