VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
8 views
Relationship between Pivot slicers
As you know, the connection between slicers on Power Pivot based on "AND" parameter.
For example, if you choose "start_date = 2003" and "end_date = 2010" it will show you the values that answer the ...
2
votes
4answers
15 views
VBA excel code for copying sheets error
I want a copier to copy one sheet multiple times. So I have made a week planning for week 1.
And now I want this sheet 51 more times. So the name has to start with a 2 and end with a 52. To make this ...
0
votes
0answers
13 views
How do I use the offset function for cells that contain text?
I would like to know how to use the offset VBA function (1,0) for cells that contain text (or at least I think this is the function that I need).
Here I am trying to get the "Freddies's Fish Fryers ...
-2
votes
0answers
16 views
VBS code in Excel 2010
Im Monching, Is there somebody who can help me to solve my excel vbs code because I'm new to this work.
the "copy to the database have some problem in which is cannot solved. I need that the entry is ...
0
votes
3answers
30 views
How to find value of one column in another and change color?
I'm new to Excel Macro VBA, so please bear with me.
I have an Excel file set up like this:
Col1 Col2
---- ----
a a
b c
c e
d g
e i
f
g
h
i
j
I want to write a ...
0
votes
2answers
20 views
vba excel: how to do a zigzag output?
hi guys i'm kinda new here so i'll go straight to the point
how do i make a zigzag output using a loop in excel
Example:
2 4 6 8 10
20 18 16 14 12
22 24 26 28 30
40 38 36 34 32
42 44 46 48 ...
1
vote
0answers
47 views
getting error “Object Variable or With block variable not set”
I have created an Add-In for Excel which determines the name of ActiveSheet and ActiveWorkbook. The code I used is below. When I run the Add-In it is showing the above mentioned error after the ...
-1
votes
0answers
14 views
Bold Row when a match is found in a predetermined list in excel macro?
Is there a way to write an excel macro where:
1) finds a match in a predetermined list
2) bolds the length of the row before until there is a blank cell
For example if the word is Cat in A1 is ...
0
votes
1answer
33 views
File Open Help - Excel Macro
I am relatively new to scripting and thus have come here to ask for some assistance to help me build an excel macro. I am currently working on an excel file to speed up data capture and verification. ...
0
votes
1answer
30 views
How to Unsort the Sorted data ( Excel VBA)
I'm now sorting some data using a VBA code. ( for some search feature)
After my search is complete I would like to unsort the data back into its original form.
How do I do that?
Thanks.
0
votes
2answers
16 views
Programmatically creating a hyperlink to a worksheet
I have been working on this for a while, I don't really know how to use vba, and I've been looking for a solution on the web for a while without success. Here is what I want to do:
I have a macro ...
1
vote
2answers
37 views
Is the type of a numeric value of a cell in Excel ALWAYS considered as DOUBLE?
In VBA, as this specification shows, numeric values can have several types: Double, Integer, Long, LongLong, Single, Decimal, Byte. However, it seems that in Excel, for a cell containing a numeric ...
0
votes
2answers
29 views
Input Prompt With Options
Is there a way to produce input prompt having multiple options in the prompt itself. User can choose any one of the option provided. As of now I am doing it using 'Input string' and then setting the ...
0
votes
0answers
14 views
QueryTable authentication
I have a VBScript which gets a data into Excel sheet through QueryTables. The script works fine, but the URL is a server which requires a basic authentication. So when the script runs the login pops ...
0
votes
3answers
40 views
How to Copy a cell's range into the value of another cell
I am writing a code that goes through a given range of cells with a for each loop. if theses calls do not satisfy an if statement withing the "for each", i need to write the range of that cell on ...
