Tagged Questions
2
votes
0answers
20 views
Excel ActiveX Listbox not enabled on file open
I am trying to figure out a bizarre situation.
I have a workbook with many sheets. On one sheet, I have one ActiveX listbox (CTOverview.Listbox1). On a second sheet, I have a total of three ...
1
vote
1answer
25 views
Excel: Runtime Error '1004' assigning VBA Array to Range without prior call to Worksheet.Activate
I generate a large matrix of doubles in a 2d VBA Dynamic Array. When I attempt to assign the Array to a Excel Range object, I receive the following error:
Runtime Error '1004':
Application-defined ...
0
votes
2answers
36 views
Excel lock and grid Error
I got this code I found in google.
(http://msgroups.net/microsoft.public.excel.misc/locking-cells-automatically-after/45998)
I need this for my work. -EDIT: I HAVE ZERO KNOWLEDGE IN EXCEL
All cells ...
0
votes
1answer
39 views
How to create a list of hyperlinks to files stored locally?
I'm trying to automate the creation of a list of hyperlinks to picture files. My worksheet has the filenames listed in column A and I want the hyperlinks to those files (saved in the parent folder of ...
2
votes
3answers
77 views
Excel 2010 Macro: Replace all cells containing number greater than AND smaller than
I have a large excel sheet in which I want to replace several number ranges (all within the same range of cells). For example, I want to replace all numbers greater than -5 and smaller than 5 with the ...
0
votes
1answer
99 views
VBA Excel Code Barcode Scanning
I have this excel spreadsheet and I'm using a barcode scanner, every time I capture something with the barcode scanner the cursor skip one column.
For example at A3 cell the info is capture so the ...
0
votes
1answer
46 views
Quick Excel Chart Reference Change
Hi I am new the site and have what I hope is a simple solution that I cannot figure out.
I have a workbook with 10 identical tabs with different data in each. I have made a new tab that references ...
1
vote
1answer
45 views
Conditional Formatting is being re-created when sheet is activated - Excel VBA
I have code on a worksheet on excel that is run every time the worksheet is activated
Private Sub Worksheet_Activate(). I have a code for conditional formatting but every time the worksheeet is ...
2
votes
1answer
33 views
Warn the User of empty cell and indicate the location based on values in preceding columns
I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user to enter data in blank cells.
I also have to mention the ...
0
votes
2answers
53 views
ssis script task corrupts excel 2010 file
I am trying to format an Excel 2010 doc and the file creates fine and the data is there, but when the script task goes to format the file it gets corrupted. I have also noticed that it will only read ...
0
votes
1answer
42 views
Formatting in excel vba takes a long time
I have an excel (2010) sheet where I load the data from a database and then format each row based on a particular cell in each row. The code for formatting takes quite a long time. About 4 minutes for ...
0
votes
1answer
34 views
Compare dates in 2 column with same ID and find latest date
I have 3 column
A = ID
B = S_Provided
C = M_Provided
In column D, I would like to populate the newest/latest Date for given ID between B & C
Here is Screenshot
Formula I have in D2 is ...
1
vote
2answers
28 views
Excel 2010 - Subtotal of values with override fields
I have an excel sheet that needs to calculate the sum of values. Values can be in one of two fields, and if it is in the second one, I want to disregard the first one.
Row1: Default value | Override ...
0
votes
3answers
28 views
Pulling data from one worksheet to another
I hope someone can help me because I have tried many suggestions from other sites, but can not find the solution.
I have 2 workbooks. One contains the list of fields to be copied to the other. So ...
1
vote
1answer
73 views
facing issue in creating pivot from data fetched form the db
i am making an excel project where user will select the date and will fill server / database name from which data will populate in the sheet that is already there in excel workbook with proper ...
