What function would do this?

#1 09-11-2015, 01:54 PM

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!

macropod · #2 09-11-2015, 11:08 PM

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

#3 09-14-2015, 06:04 AM

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!

macropod · #4 09-14-2015, 07:15 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
#REF! Error in calling VBA function disappears when function is copied	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
IF function	msheyworth	Excel	2	03-28-2013 02:15 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM
if function help	jim831	Excel	2	10-29-2010 07:06 PM