Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 09-29-2013, 05:45 AM
BobBridges's Avatar
BobBridges BobBridges is offline Detecting last cell within a block Windows 7 64bit Detecting last cell within a block Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Don't misunderstand me, Peco; I don't disagree. But in this case, the OP himself said he's still thinking about a VBA solution, you sneered mildly about reinventing the wheel and in defense of Funk I pointed out several reasons why people may want to do that. That's really all there was to it.

In Funk's case particularly, there may be good reasons why he'll need VBA in the long run. Your solution works well if he just needs to glance at the worksheet and see the latest "Done" proc identified for each block. But if he had needed (or if he ever needs) the summary of that information listed on a separate sheet, I think it can be done with formulae but it may be simpler to use VBA. He never said.

[Later:] I take back the second paragraph. I just looked at your solution (I only glanced at it before), and it deals with that question, better than my approach would have. I'll have to study it more closely to see how you did that.

(What is "OP", anyway?)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Detecting last cell within a block Block a page HMS Word 2 07-12-2013 04:40 PM
Detecting last cell within a block Detecting Page Breaks in Mail Merge Directory TimK9VB Mail Merge 6 11-20-2012 01:52 PM
Detecting last cell within a block detecting triggers yisuz PowerPoint 1 05-15-2012 09:16 AM
Detecting last cell within a block block a PP document from printing Paldo PowerPoint 1 05-14-2010 10:20 AM
Detecting Who Opened in Email In Shared Folder jerem Outlook 0 03-20-2010 10:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.


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