Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2015, 01:54 PM
namedujour
Guest
 
Posts: n/a
Default What function would do this?

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!
Reply With Quote
  #2  
Old 09-11-2015, 11:08 PM
macropod's Avatar
macropod macropod is offline What function would do this? Windows 7 64bit What function would do this? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 09-14-2015, 06:04 AM
namedujour
Guest
 
Posts: n/a
Default

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!
Reply With Quote
  #4  
Old 09-14-2015, 07:15 PM
macropod's Avatar
macropod macropod is offline What function would do this? Windows 7 64bit What function would do this? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
What function would do this? #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
What function would do this? IF function msheyworth Excel 2 03-28-2013 02:15 AM
What function would do this? Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
if function help jim831 Excel 2 10-29-2010 07:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft