-
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.
endif
-
Dynamic variable name?
Suppose I have undeclared variables called: config1 config2 How can I make these dynamic in a FOR loop. For x = 1 to 2 if "config" & x = "something" then 'do something endif next x- Roderick_E
- Thread
- config dynamic endif loop undeclared
- Replies: 3
- Forum: Excel Questions
-
Y
MsgBox problem
Hello all, I have a problem with my VBA, maybe you can help me. Everything is working fine, but even if XXX!D13 =0, i still recieve an empty message with "ok" button. How can i change the vba, so that in case XXX!D13 is zero, not to have any message. This is my VBA: Dim msg AsString If...- Yulyo
- Thread
- endif msg msgbox vbcrlf xxxd13
- Replies: 4
- Forum: Excel Questions
-
R
Excel vba code
Hello All,<o:p></o:p> I have Sheet1 , Sheet2 and Sheet3 in a workbook. <o:p></o:p> Can anyone edit the code vba code below to make it work justonly SHEET1 and not other sheets. <o:p></o:p> Thank you. PubliccurSheet<o:p></o:p> PrivateSub btnsearch1_Click()<o:p></o:p> Dimi, LastRow, caseFound...- RJ1969
- Thread
- case endif false i.value true
- Replies: 1
- Forum: Excel Questions
-
B
Cannot resolve compile error - EndIf without block If
I am getting an "EndIf without block If" compile error. If anyone is able to assist I would greatly appreciate it. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("O2").Address Then Range("P2:U2,O5:P5").ClearContents End If If Target.Address =...- brought
- Thread
- blockif compile error endif
- Replies: 10
- Forum: Excel Questions
