What function would do this?

macropod · #1 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

#2 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!

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