Tagged Questions
0
votes
2answers
24 views
Merge cells in Excel between x and y
I have data in excel that varies between 5 - 6 cells long, with 3 spaces in between.
I wish to group all data between :
Post to:
x
x
x
x - maybe; this isnt always here
Australia
So all data ...
0
votes
1answer
113 views
VBA subtracting address
I was just wondering will it be possible to subtract something from an address? I mean like data.Address -1?
I have here a code that would return the address of a cell based on a keyword. what I ...
0
votes
2answers
20 views
VBA clear formatting from selected paragraph
Having a lot of trouble with this macro:
ActiveDocument.CopyStylesFromTemplate NormalTemplate.FullName
With Selection
.Style = ActiveDocument.Styles("Normal")
...
0
votes
0answers
33 views
Batch add a macro to word documents?
I have several hundred .doc word documents which I need to add a macro to which runs when the .doc file is opened and creates a header for said document based on the file name. I was hoping someone ...
0
votes
0answers
21 views
Enabling Macros Causes Excel To Freeze & Crash
Please advise! Been working on this file for about a week now and finally finished a VBA Macro I was coding yesterday. I ran it this morning, and it worked fine. Unfortunately, just af ew hours later ...
1
vote
1answer
36 views
How to do a row count in VBA to see if I need to pull down a calculation?
I am about as new to VBA in Excel as you get... I'm now looking at a Macro that is having some issues with calculations when only one row of data is returned (it's causing all proceeding rows to ...
0
votes
1answer
18 views
I need place values in the correct location on the newly created template sheet
I have some code here that would create a new template sheet for every unique cell in column A. It then distributes column E,F, L and O to its appropraite positions in the newly created template ...
0
votes
1answer
32 views
How do I do Conditional formatting on Macro
I have got a spreadsheet where a user is to choose a job title from a drop down list and the according to that job title certain cells are highlighted with appropriate training course.
For example ...
0
votes
1answer
33 views
Excel VBA Macro to add a row when value changes and populate that row
I'm trying to build a macro in excel that will take a bunch of data like this:
D 1 2 3 4 5
D 1 2 3 9 5
D 1 2 3 4 5
And process it to insert a row when a value in column 4 differs. I also want to ...
0
votes
1answer
16 views
How do I get a macro to run the same operation but with 2 seperate workbooks, not the same ones I used to record the macro?
I hope this is a clearer description of what I want to achieve.
I just did a copy and paste values only and it did the operation for me. I was hoping a macro might speed the process up a bit. ...
0
votes
1answer
56 views
Excel Macro to search folders and return files containing specific keyword and most recent version
I am looking for some help on writing a macro that will search a folder in my computer to see if any of the files in the folder contain a specified keyword, then return the file name, path and last ...
3
votes
1answer
31 views
excel vba open dialog to import csv
I have this vba code below that was generated by the macro recorder. It imports a csv file into the current excel sheet with some specific column settings. Right now the path to the csv file is hard ...
0
votes
1answer
20 views
Generating word file in the same directory of excel using excel vba
I was trying to open a word file using excel macro & copy & paste some data from excel to the opened word file. Then to save as the word file in the same directory of excel file. But facing ...
0
votes
1answer
14 views
Outlook-2007 VBA macro Do For all open emails and move to a folder
I believe i have something that should be fairly quick and easy to create. Our company is using the Enterprise Vault system to store all our archieved emails and well it is horrible. 10% of the time ...
1
vote
3answers
45 views
Excel macro to insert function
I'm trying to write a macro that will place a formula under a column of numbers, such as sum or average. I came up with this:
Sub foo()
ActiveSheet.Range(ActiveCell, ...
