Tagged Questions
-1
votes
0answers
4 views
Excel: Runtime Error 13 for DateAdd one column to another column
New to coding-- please bear with me!
I'm trying to create an event procedure for a date add that starts when workbook open and when a worksheet change happens.
A "Closeout" date is manually input in ...
0
votes
2answers
12 views
Excel Error 1004 - Run-time error '1004' Application-defined or object-defined error
I'm trying to clean up my spreedsheet. There are many blank cells which are throwing off the count. I tried using this code but it's giving me a run-time error.
Sub ClearAll()
Dim c As Range, ...
1
vote
1answer
32 views
Delete Cell based on Color Index
I have data which shows me duplicates between two lists. I'm trying to delete the cells which have duplication to only show me the ones that don't match. Therefore, I can't delete rows but can only ...
0
votes
1answer
24 views
Excel VBA - populating table from various woorkbooks via vlookup
Could you please give me a hand with making below code work? It should be fairly self-explanatory. I've only recently started to use VBA and hence am quite unfamiliar with many of the commands. Thanks ...
1
vote
1answer
60 views
Excel VBA: More efficient way to pull in data from another workbook?
All,
As a temporary fix before we transfer the process over to our CRM system, I've written a tool with Excel/VBA that allows the user(s) to do some territory planning.
This tool opens a workbook ...
-4
votes
0answers
26 views
How to get GOLD price from a website to the excel [closed]
I need to get the gold price & silver price from www.gold.ae to cell
A1 & A2
A1 = Gold Price
A2 = Silver Price
I'm a newbee and only basic coding knowledge i have, tried so many options but ...
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
4answers
61 views
For-Next Loop and Arrays - VBA
I keep making the same mistake, and I have no idea what it is. Every time I make a For-Loop dealing with arrays (usually, trying to read one array and write the values in a second array), it just ...
0
votes
2answers
62 views
Does the += operator just not exist in VBA?
I'm trying to incriment the value in a cell, but despite documentation saying Visual Basic allows the += operator, it's just giving me "Compile error: Expected: expression".
Range("CellName").Value ...
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
23 views
VBA How to get Multiple Selections with .Selection
I haven't been able to find a helpful solution to this. Maybe someone on here might know the answer. My macro requires the user to have a source and destination cell. To do this the selects the ...
1
vote
1answer
36 views
Check multiple columns for values then perform operations on them
I have an excel sheet with values in ranges E10:1610 and if cell J5 is equal to "Yes" I want to use vba to check the entire range of columns for values higher than 10. Add all these values together ...
0
votes
1answer
18 views
Word 2007 VBA: Need to return a custom document property as a string within VBA Code
As part of a SharePoint workflow, a custom document property named "Link to Graphic As Text" is filled in with a link to a graphic provided by the user. I'm trying to code a macro within the Word ...
0
votes
2answers
21 views
copying activex controls along with the macros
Is it possible to copy an ActiveX control to a different worksheet along with the macro associated with it?
Thanks
