**0**

votes

**0**answers

161 views

### vba excel macro runtime error 1004

Dim lastC As Long
lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug
SourceRange.Copy
wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...

**0**

votes

**1**answer

75 views

### Word VBA parse text and turn it into a table

Input:
##TABLE_START##
##ROWS=3
##COLS=2
##Value
##Decode
##0
##Clock running
##1
##Clock not running
##TABLE_END##
##TABLE_START##
##ROWS=4
##COLS=2
##Value
##Decode
##0
##Off
##1
##On
##Z
##High Z
...

**0**

votes

**1**answer

107 views

### modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...

**0**

votes

**1**answer

55 views

### Powerpoint VBA References

I am writing a VBA code on Powerpoint, where I need to call and excel file for input. Programme is functioning fine, runs without error, and generates output, except for the part where Excel file is ...

**1**

vote

**2**answers

37 views

### Code iterating slowly

I have a simple macro that gets creates 16 different versions of a template, updating by getting values from another open workbook. It is taking over a minute to iterate only 16 times and was ...

**0**

votes

**1**answer

316 views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**-1**

votes

**1**answer

287 views

### Break the forgotten encrypted password of excel workbook

i have an Excel 2010 workbook, on which i applied an Encrypted (128 bits AES) password, which i can't remember now, is there any way to remove/reset or retrieve that password or any method to retrieve ...

**0**

votes

**0**answers

55 views

### Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn.
I want to insert a column and the default value to that entire column should be CH. column ...

**0**

votes

**1**answer

64 views

### Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...

**0**

votes

**1**answer

21 views

### Formula to determine available options based on prerequisites

Example:
A spreadsheet for a single studient has four columns: Course|Completed?|Prerequisites|Available
The "Course" column lists the names of courses.
The "Completed?" column indicates a "yes" if ...

**0**

votes

**2**answers

38 views

### Specific Row Values in Excel

How can one ask Excel to record the value of all cells in a given column such that the row number is of the form row = 2^i for i in 1 to 100? Would this necessarily use VBA?

**0**

votes

**1**answer

52 views

### Copy a specific cell on all sheets to master sheet

I have a master sheet with the format as below:
Master sheet
Column A Column B Column C
No Description Price
And multiple sheets with the format below:
Sheet ...

**0**

votes

**3**answers

174 views

### EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below.
...

**2**

votes

**1**answer

24 views

### Convert tracked changes to highlighted

I am looking for an automated way to convert tracked changes in Microsoft Word 2010 to highlighted text. So, in essence what I'd like to do is:
Highlight all text fragments with tracked changes
...

**1**

vote

**1**answer

2k views

### Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...

**0**

votes

**1**answer

15 views

### Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items,
with different information in all columns ,although certain columns might have duplicate information.
I can do conditional formatting and highlight the ...

**0**

votes

**1**answer

68 views

### User Input to Select and Fill In value for Cells

I have this excel table: A2 to A11 are class names Class_1, Class_2,..., Class_10.
B1 to K1 are student name 1,2,3,...,10
For each student in his class, I will need to fill out his grade
I would ...

**0**

votes

**1**answer

50 views

### merge two exel sheets and update duplicate value

I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...

**0**

votes

**1**answer

51 views

### Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F)
I need to list only those data from columns A/B/C when column B data has no corresponding ...

**2**

votes

**1**answer

142 views

### Adding attachment option to scheduled email vba script

I am learning VBA, but for the time being I am not that good and I found this macro:
Scheduled and recurring email in Outlook?
It sends an email thanks to a scheduled appointment set in the ...

**-1**

votes

**1**answer

93 views

### Automation Error Catastrophic Failure

I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...

**1**

vote

**1**answer

53 views

### Excel automatically adding an extra row with formulas for the inputed number of years

I am looking to build a model. I would like to have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...

**0**

votes

**1**answer

167 views

### How to automatically replace Excel formula with value when date/time condition is met

I need to record results of a constantly changing cell based on external criteria.
Cell B3's value is changing, and I need to record the value of B3 at specific points in time. Cell D2 contains the ...

**0**

votes

**1**answer

32 views

### Excel: Referencing a named range inside a formula

I have two tables, the first table has 6 column and each column has a defined range name as follows:
Col 1: Broker_Name
Col 2: Broker_Market
Col 3: Client_ID
Col 4: Client_Location
Col 5: ...

**0**

votes

**2**answers

423 views

### How to add custom styles to navigation pane or change them with VBA

I have a Word2010 document that was created by a tool from Axure.
Each heading is formated with a custom style ("AxureHeading1", "AxureHeading2", "AxureHeading3").
I was able to create a table of ...

**0**

votes

**1**answer

46 views

### Excel - import data from cell automatically when a new tab is created

I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs.
Is it possible to automatically import data from a specified cell into a ...

**2**

votes

**2**answers

32 views

### I would like to copy data from 1 row to another in Excel

I am trying to solve the following issue in excel: I am working in two sheets, Sheet 1 and Sheet 2. There is a column of data in sheet 1 (say from A5 to A20). I need every row from that column to be ...

**0**

votes

**1**answer

76 views

### Using VBA to calculate unique random numbers in “i” number of rows

I am currently working on a pet project of mine. I am currently making a combat calculator for a gaming group I DM. Essentially, I have a table with the monsters and their stats, and a cell with the ...

**1**

vote

**4**answers

2k views

### Excel VBA - adding an element to the end of an array

Simpel Question I like to add a value to the end of an array and increase it automatically? I was not able to find such a simple example
Public Function toArray(range As range)
Dim arr() As Variant
...

**0**

votes

**0**answers

71 views

### Set default outlook send address based on TO field

Is there a way to have outlook pick the right email address based on the TO or CC fields?
For example, if I am sending an email to domain1.com, use account1@domain2.com, else ...
I am open to ...

**0**

votes

**0**answers

16 views

### Adding numbers based on their relative position in a worksheet

I have nearly 10,000 numbers arranged on an excel worksheet to form the map of USA.
Now I want to separately add the numbers based on below mentioned four criteria:
1.0 Corner cells i.e cells flanked ...

**0**

votes

**1**answer

62 views

### Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...

**0**

votes

**0**answers

76 views

### comparing two columns for matches then return values meeting certain conditions

I have the following:
column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300)
column H ( 50 values )
column E & column F & Column G; they are to ...

**0**

votes

**1**answer

1k views

### How to bypass the VBA project password from Excel

I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we ...

**0**

votes

**1**answer

485 views

### Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed

I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter ...

**-2**

votes

**1**answer

50 views

### VBA dates filter [closed]

easiest way to explain this is to use a example.
I have two dates(f.e.) "2014-08-08T8:11:31" and "2014-08-11T13:53:29".
I need to gave them proper form(date),exclude weekend(Saturday, Sunday ) and ...

**0**

votes

**3**answers

1k views

### Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...

**0**

votes

**1**answer

30 views

### extracting labels of data in a pivot table

When I move the mouse pointer over data in a pivot table it displays what are the row and column labels (names of pivot items).
How can I extract them so I can later use them in a code (when I want ...

**1**

vote

**2**answers

202 views

### Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...

**0**

votes

**1**answer

72 views

### Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20)
The 3 columns are each 1 digit of a 3 digit number.
Some of the rows have 3 digits, some are blank.
I need a way to return all the non-blank rows of 3 ...

**2**

votes

**1**answer

113 views

### Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here:
Excel function that evaluates a string as if it were a formula?
Problem is this does not seem to work with a function in there.
This ...

**0**

votes

**0**answers

39 views

### Keep header text in Excel, but change font

I've seen several examples for changing the header font in Excel; however none of them just change the font. They seem to always incorporate static text or a cell reference. How do I change just the ...

**0**

votes

**2**answers

1k views

### How can I trigger an Excel macro by hovering a mouse over a cell?

I have not been able to figure out how to run an Excel macro by moving
my mouse over one or more cells in my spreadsheet.

**0**

votes

**1**answer

49 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**5**

votes

**2**answers

187 views

### How do I add VBA in MS Office?

I've seen posts showing answers which use VBA (Visual Basic for Applications) code/macros, however, I've also noted additional comments afterwards about how to use the VBA (how to implement it). I'm ...

**0**

votes

**3**answers

599 views

### Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C.
For example, using the table below, it searching in ...

**0**

votes

**1**answer

48 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**0**

votes

**1**answer

169 views

### Excel: Find a specific cell and paste the value from a control cell into it

I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer.
I want to enter a different, manually determined, integer in a third column.
Whether by macro ...

**1**

vote

**1**answer

95 views

### VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure:
Fill one cell with a formula, where arguments to ...

**0**

votes

**1**answer

86 views

### Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example:
User enters the ...