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
1answer
12 views
selecting active row and first row in VBA Exel 2010
How can I select the row associated with the current active cell AND the first row?
I have:
Rows(ActiveCell.Row).Select
Range("1:1").Select
But when the second "Select" is run, it removes ...
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, ...
0
votes
4answers
20 views
pastespecial method of range class failed
I looked at a few similar questions at the site but seems like none of them did the trick.
I am trying to create a new workbook. Copy the content of its active sheet and paste it to this newly created ...
-1
votes
1answer
27 views
Hiding certain rows with VBA
How would I set up a loop that goes through every row in a large sheet and hides the row if the letter Q is in a cell in that row.
I dont know the syntax very well...
Sub Macro4()
...
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
0answers
29 views
When to use Set in my VBA code?
To my astonishment, I realized that I could not set a range at some point of my code. And I've found nowhere any mention of this issue.
So I declared (with dim) a Range variable.
And then I do Set ...
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 ...
0
votes
0answers
14 views
cannot change pivot item visibility
I am trying to write a Macro to build up a pivot table. And I also want to filte out some pivot items in Row field. Here is How I do it:
Set objField = objTable.PivotFields("RC 1")
...
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 ...
2
votes
2answers
50 views
VBA Cutting string after last word less than 80 characters total length
I am:
using the Excel Clean function to strip all formatting off any text, and
then I want to break the resulting long string into separate rows of 80 characters or less.
the only delimiter ...
1
vote
1answer
27 views
shtDestination based on referenced cell
this might be quick for someone who knows so I will appreciate any help...
I have this code:
Dim shtSource As Worksheet
Dim shtDestination As Worksheet
Dim nSourceRow As Long, nDestRow As Long
...
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
1answer
36 views
EXCEL VBA Error: “Compile Error: Expected Array”
Can anyone help me?
I have been getting a compile error (...: "Expected Array") when dealing with arrays in my Excel workbook.
Basically, I have one 'mother' array (2D, Variant type) and four ...
