-
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.
.ignoreblank
-
VBA query if top cell is blank.....
Hi everyone, I need help again. I've written a fleet management spreadsheet and I'm having problems with a piece of code that takes filtered information from one sheet and moves it to another. Code is as below; A3 is header row, if A4 is empty, code bugs out, where it should just be...- anna82marie
- Thread
- .ignoreblank help vba
- Replies: 4
- Forum: Excel Questions
-
D
Amend a data validation list code to accept lowercase letters?
Hi, Here is my code: With ActiveCell.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, Formula1:="D, E, F, G, H, J, K, L, M, N, P" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = ""...- danbates
- Thread
- .ignoreblank .incelldropdown amend code true
- Replies: 3
- Forum: Excel Questions
-
F
Activecell.offset
Hi I need to use the code below to attach a data validation list to columns K, L and M. The only thing is the row for each sheet is different hence the use of Activecell. The code I have is: Sub IntList()' ' IntList Macro ' Range(ActiveCell.Offset(1, 0)...- Fazila
- Thread
- .ignoreblank column end selection.validation true
- Replies: 4
- Forum: Excel Questions
