Tagged Questions
0
votes
0answers
6 views
VBA ERROR : object variable or with block variable not set
vba error: object variable or with block variable not set
I have no idea what has just happened! Please help. Here is my code!
If intMsgBox = vbYes Then
Unload frmNewOrder // error here
Unload ...
-1
votes
0answers
14 views
Connect to server
I'm trying to connect to database with excel. Obviously excel doesn't have option to connect through FTP. But it could be done with VBA code. I tried to look for VBA code I found couple examples. I ...
0
votes
0answers
22 views
Excel VBA: How to create a chart from a text file (.csv)?
I am running a model that simulates contaminant transport in an environment. To do this I have created a for next loop and saved the data in a text file (since an array couldnt hold all of the data). ...
-1
votes
1answer
17 views
rearranging cells in excel
let me first give you the background. I had a pdf file which had list of workers in company. the file consist of workers name, department and email address with few more details. I need all those ...
0
votes
1answer
22 views
Custom Auto-Sort Macro Excel
I would like to customize the below macro. What I would like the macro to do is auto-sort as per the below list. Any suggestions on how I could go about doing this?
Thank you.
Code:
Private Sub ...
-2
votes
0answers
30 views
Create an “if then statement” or UDF
How do I create a User Defined Formula or a VBA that does the following:
Looks at the values in range B1:B3 if the value matches cell H11, paste the value of cell A1 into the cell A10
Then if a ...
0
votes
2answers
11 views
How to use variables in range assignments
I would like to use variables that I can pass to a SUB for coping an array from one sheet to another sheet in another workbook. Without variables this works well for me:
Dim RNG1 as Range, RNG2 as ...
0
votes
1answer
7 views
insert a chart object at a specific location
I have written a macro in excel to insert a chart.
The macro is run when a particular range of cells is selected.
It is:
Sub drawchart2()
'
' drawchart2 Macro
'
'
Range("B24:C36").Select
...
0
votes
1answer
20 views
How can I make this Excel macro loop through only visible filtered data?
I have very little experience with VBA and I'm now stumped by what I'm trying to accomplish with a macro. Excel 2010.
I have 3 relevant columns. B, C, and AD. (Columns 2, 3, and 30)
My data is ...
0
votes
1answer
18 views
Reorder hidden tabs in excel
At work, we've developed a tool using Excel and VBA. This tool has hidden sheets that will only be opened once the previous step is complete. One of the issues I'm running into from the previous coder ...
0
votes
0answers
32 views
VBA: Referencing a named range and insertation of that named range
Sub Sort3(a As Range, b As String)
' This
' First part checks for player salary and descending then if true, then clears and sorts descending
If b = "Descending" Then
...
0
votes
1answer
24 views
Copy filtered cells to another sheet
I have four rows of information that I filter. (month, Name, Service, units) I filter the information by name and month. (depending on information needed) I have put together the following to try and ...
0
votes
1answer
19 views
Vba Excel: Is it possible to Clone Form Control?
I have to generate hundreds of form control dropdowns with same item values. So i would like to clone them if possible. And i should be able to change few attributes like Name, OnAction Any ideas ...
0
votes
1answer
16 views
How to count a variable with two conditions VBA Excel
I'm working on a project about housing on my campus, University of Illinois Urbana-Champaign.
I want to count based on two conditions: if the house is a fraternity (coded as "1") and if it is in ...
0
votes
1answer
14 views
Trying to get value from an input file sheet throws Runtime Error '13': typemismatch
I'm new to VBA and I'm trying to access the files that I select with 2 GetOpenFilename, the thing is
I have my two GetOpenFilename inside
Private Sub Workbook_Open()
MsgBox "Please select Inventory ...
