-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
end sub
-
M
VBA, If Cells Blank End Sub
Hello everyone, A simple one no doubt........I have inherited the below code and would like to amend to include a statement at the beginning to echo the following: IF CELL Z1 ON SHEET 6 IS BLANK THEN END SUB, OTHERWISE DO ALL THE BELOW. Can anyone advise please? Thanks very much in advance...- MrMaker
- Thread
- end sub vba excel
- Replies: 2
- Forum: Excel Questions
-
Please help me edit my VBA code/formula
Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...- Jyggalag
- Thread
- code dim easy easz email end sub for cycle formula help basic index indexmatch match set set as range sub vba visual baisc vlookup
- Replies: 4
- Forum: Excel Questions
-
D
VBA one cell returns date of last time another cell was edited
Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...- David77
- Thread
- application code enableevents end if end sub error excel help intersect macro now now function offset range rng rng as range run-time error target vba workrng
- Replies: 1
- Forum: Excel Questions
-
G
Excel VBA - Data Validation List Automtic Macro
Good Day, I am helping acolleague of mine with some VBA code I am rather inexperienced with. She has aData Validation drop down list to select from. When a user makes a selectionfrom drop down, it hides and unhides specific rows based on what the colleaguewants the user to see. The code works...- Gian624
- Thread
- drop dow end sub list upon delete vba
- Replies: 10
- Forum: Excel Questions
-
M
Variable Cleanup at End of Sub Routine, Function and Excel Itself
I dimension many variables in various subs and functions. What steps do I need to take to clear everything from memory upon completion of the function or subroutine? Also when I close the spreadsheet, is there a way to clean up anything I left messy. With Excel 2016, I just shut it down from...- MikeDBMan
- Thread
- end sub
- Replies: 1
- Forum: Excel Questions
-
S
End sub creates "Runtime Error 91: Object variable or with block variable not set"
Apparently this happens when a variable is not defined, but all mine are, as far as I can tell. Also, when debugging, the error appears on the End Sub line. That is, the macro (seems to) exit correctly, but as it exits I get the error msg. If the error box could be forced to not appear it would...- SeanWise
- Thread
- call a sub end sub error 91 variable assignment vba & excel
- Replies: 5
- Forum: Excel Questions
