![]() |
#1
|
|||
|
|||
![]()
I need something that looks for the first open cell in a column. Is there a function that does this? Or better yet, does Microsoft have a preprogrammed macro I can add to my Quick Access Toolbar?
Thanks! |
#2
|
||||
|
||||
![]()
You could do it with a macro like:
Code:
Sub Demo() Application.ScreenUpdating = False With ActiveSheet.UsedRange On Error Resume Next .Range(Split(ActiveCell.Address, "$")(1) & .Cells.SpecialCells(xlCellTypeLastCell).Row).Offset(1, 0).Activate .Range(Split(Split(ActiveCell.EntireColumn.SpecialCells(xlCellTypeBlanks).Address, ":")(0), ",")(0)).Activate End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
I tried this, and get "Can't execute in break mode." I just did a copy/paste into Macros. I don't edit macros much in Visual Basic, so I don't know how to troubleshoot. Could you please advise?
Thanks! |
#4
|
||||
|
||||
![]()
It seems you have a suspended macro that needs to finish before you can run this one. See: https://msdn.microsoft.com/en-us/lib...or=-2147217396
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
![]() |
msheyworth | Excel | 2 | 03-28-2013 02:15 AM |
![]() |
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |