3
votes
0answers
554 views
Excel VSTO fails to load if there's VBA macros
I have an excel XLS developed with Visual Studio Tools For Office (VSTO) 2005. Most of the code is in C# VSTO, but there is also a VBA macro to implement a worksheet function. I'm not trying to have ...
2
votes
0answers
438 views
Excel worksheet - if the column contains X then copy the row and all rows with the same word in column A to sheet 2
The current code copies content from sheet 1 to sheet 2 if X and from sheet 1 to sheet 3 if Y. I need it changed so that if a row in column B = X it copies every row that has the same word in Column ...
2
votes
0answers
242 views
How to release an vb.net class libary object from Excel VBA
as the performance of Excel VBA was to poor for my calculations, I migrated my code to a VB.net class libary which I add as a reference in Excel. I am using VBA for all my read and write function, but ...
2
votes
0answers
149 views
Regroup data automatically
I would like to group data in my Excel in a automatic way (by using a macro)
For example, in my column A, I have fields tuck as this:
in A1 I have " 1.0.1",
in A2 " 1.0.3",
in A3 " 1.0.5",
in ...
2
votes
0answers
252 views
Look up Column number in a range?
I'm trying to use the filter option to filter my range.
ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=11, Criteria1:="yes"
Basically that will filter Column U for yes.
What I have is a ...
1
vote
0answers
23 views
VBA Excel - UPDATE record in ACCESS
I got a problem.
I want to update an existing record in table in Access Database using VBA in EXCEL.
My code:
sqlik = "UPDATE query which works in access"
Set ZAP_QUERY2 = ...
1
vote
0answers
22 views
edit the program to sumif with visible cells in MS excel
i got some countifv thats counts visible and sumifsv which sum visible cells only ... i want sumif only visible using vba
Default Using SUMIFS on visible lines only
I have a large table, lots of ...
1
vote
0answers
29 views
SharePoint + Excel with Macro
I'm trying to figure out how to move an Excel spreadsheet from a mapped drive to SharePoint.
We have an engineering department who uses this spreadsheet to keep an active list of job and job numbers.
...
1
vote
0answers
70 views
Prevent duplicate copy paste in excel
Hi all the noob is back again. I am doing a copy paste job of data from one worksheet into another which is hidden but there is a danger that data will be duplicated if not checked against what has ...
1
vote
0answers
53 views
Showing names in Excel cells does not work
I use this function (this is Excel 2007, file type is *.xlsm)
Public Function CellName(oCell As Range) As Variant
Dim oName As Name
For Each oName In ThisWorkbook.names
If ...
1
vote
0answers
28 views
Excel 2013 - Command bars issue
I have a VB6 Addin DLL which creates a Toolbar buttons (using Commandbar object) in Excel .
Code works fine in Excel 2007 & Excel 2010, But fails in Excel 2013.
Problem Description
Addin DLL is ...
1
vote
0answers
125 views
Excel VBA loop logic
My brain hurts.
Part 1 of 2. Apologies for the ugly - I typically learn and use VBA only as I need it, so my eloquence in the language is a little lacking.
I've been trying to come up with a way to ...
1
vote
0answers
92 views
Can a cell have both data validation and vlookup at the same time?
Basically I have 2 cells. One is a product description and one is a product number. The way it exists now, the product description is data validated and the product number is a lookup by description.
...
1
vote
0answers
198 views
Color Points (Bars) in Pivot Chart based on Row Labels (Axis Fields)
I'm trying to automate a process that so far I have been doing manually in Excel 2010. I create Pivot Charts often. One of the series on these charts is displayed as bars. I change the fill color ...
1
vote
0answers
32 views
Data Validation stopped working when I merged workbooks
I used visual basics to merge 8 workbooks together; however, when I did that my data validation stopped working on all except the very first page of the new workbook. Does anyone know why this may ...
