Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-23-2013, 03:01 PM
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

Funk, I have a notion about how to find out using formulae. But I'm a little hazy on how that information is best presented. That is, I can see a running column down the same page that says (for example) "Block1.Proc2", and then a bunch of blank cells and then "Block2.Proc4", and so on down the page, so that the eye will be caught by the cells that have writing in them and the rest of those cells are blank.

But if you want them in a separate worksheet as a consecutive list, I expect it's possible—I've done that sort of thing—but it's a little kludgy. VBA would be the more obvious choice, but then VBA does you no good unless you know how to write programs—and if you knew how to do that you wouldn't be how to do it in VBA. So I guess the next question (unless you want to learn VBA) is how you want this information presented....?
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 03:49 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