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!

Thread Tools
Show Printable Version Email this Page Mark this thread as unsolved
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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