VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
12 views
For-Loop to assign index value Excel VBA
Apologies for the naive nature of this question but I am very new to VBA.
I have a column of data with the number of pageviews a particular page has had.
I then have a seperate sheet that assigns ...
0
votes
2answers
14 views
Copy Paste macro is inducing 'grouped'-worksheet functionality?
I am getting an error I can't figure out:
After I run the macro below, two certain string values are pasted into the same two cells in ALL sheets, although I am sure that the sheets are not grouped ...
0
votes
2answers
17 views
compiler error calling a private sub procedure
Private Sub Workbook_SheetSelectionChange _
(ByVal Sh As Object, ByVal Target As Excel.Range)
x = Sh.UsedRange.Rows.Count
End Sub
I have a private sub procedure like this and I am ...
0
votes
1answer
15 views
Check for lines in txt file starting with particular word and count the occurences
I've been trying to check if a given txt file has lines that start with a particular word. I then want to count the number of lines that start with that word. Though I can't quite get it right, I do ...
0
votes
1answer
33 views
How to reverse the order of rows
I try to write a macro that would reverse order of rows in my Excel worksheet, but unfortunately I fail. I don not know even how to start. I would be very grateful for any help or hints on how to do ...
0
votes
1answer
10 views
Excel COM: Prevent auto calculate cells when opening workbook
I have a workbook in which the calculation of cells is set to automatic. This means that calculation will start when I open the workbook.
How can I prevent the calculation to start when I open the ...
0
votes
0answers
25 views
Open a workbook (mode automatic) by VBA command without recalculating it
In my VBA addin.xlam, I use workbooks.Open("C:\f.xlsm") to open workbook f.xlsm. The workbook calculation mode of f.xlsm is Automatic, thus I realize that everything in f.xlsm is recalculated ...
0
votes
0answers
15 views
Copy Paste through function is not working
If the Column A cell value is pass then Column B cell value should be moved to Column C.
E.g:
When Column A=fail
Column A Column B Column C
Fail 123 blank
Fail 345 blank
...
0
votes
1answer
15 views
Excel: get cell collection of cells that contain certain text or formula
I have a worksheet with 1 or more sheets and numerous filled cells per worksheet. I need to go through all cells that have a certain text and/or formula.
What is the quickest way to do this (in ...
0
votes
2answers
22 views
Excel: Recalculating every x seconds
One of my spreadsheets deals with various calculations involving, among other things, the current date and time and it would be nice to have it automatically refresh itself once in a while instead of ...
-1
votes
1answer
12 views
How to create a date formatted cell with correct date using title of sheet plus text in a cell?
Trying to figure out if this is even possible:
All cells are in 'General' format. So it's all strings, I think.
A1=blank, B1=6, C1=7, D1=10, E1=11, F1=12, G1=13, H1=16 etc (note the gaps in the ...
0
votes
0answers
19 views
How to combine reverse-chronological sheets while rearranging cells, preventing stacking?
OK, I will try to explain this well. An odd problem to solve, and it's WAY beyond my skill level (novice).
Excel 2011 for Mac.
The workbook has 11 sheets.
Sheet names are all 'Month Year'. (Eg: sheet ...
0
votes
1answer
18 views
how to add a child node to an xml in excel vba
I have template of an xml like this
<?xml version="1.0" encoding="UTF-8"?>
<manageServiceProfileRequest xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
...
0
votes
1answer
23 views
VBA Userform: Accessing different Charts depending on Combobox
I am a beginner with VBA, and only have some experience with MATlab.
At the moment I am trying to use a Userform to display different graphs (on that same userform), depending on the output of a ...
0
votes
1answer
24 views
Macro: Transposing issue
Wonder if someone can help me with this one
Using VBA, I have set up a macro which starts by transposing a pivot table into another sheet then touches up the data automatically into a tidy little ...
