Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem
Excel - Selection range problem Excel - Selection range problem
Excel - Selection range problem
Go Back  Xtreme Visual Basic Talk > > > > Excel - Selection range problem


Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2003, 05:57 AM
biafra biafra is offline
Newcomer
 
Join Date: Mar 2003
Posts: 1
Default Excel - Selection range problem


Can anyone tell me: how does Excel macro know the beginning and ending row number of the range user selected?
(I'm writing a macro that formats every other unequal cell in a range of cells that user selected in a worksheet. The contiguous cells that have same values should be contiguously formated or contiguously not formated)
I tried Selection.End(xlUp).row i .End(xlDown).row, but they don't work in this case, since I want to limit the formating only to user's selected range, not to format entire row of data.
Is there some other Selection.attribute?
Reply With Quote
  #2  
Old 03-19-2003, 06:03 AM
MillExcel - Selection range problem Mill is offline
Ultimate Contributor

Retired Moderator
* Guru *
 
Join Date: Feb 2000
Location: Michigan, USA
Posts: 2,643
Default

Try ActiveWindow.RangeSelection.
__________________
"The face of a child can say it all, especially the mouth part of the face." - Jack Handey
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97 (Late Binding) problem beans4you Word, PowerPoint, Outlook, and Other Office Products 27 02-09-2003 03:45 PM
Help with problem with Excel Automation within VB6 seidenstud Word, PowerPoint, Outlook, and Other Office Products 1 12-18-2002 11:44 AM
best way to access other MS applications internationally Word, PowerPoint, Outlook, and Other Office Products 1 10-21-2002 07:51 PM
macro to update Excel file (simple but for one big problem) internationally Word, PowerPoint, Outlook, and Other Office Products 11 09-11-2002 08:40 AM
Word Problem & Excel Problem bri822 Word, PowerPoint, Outlook, and Other Office Products 5 08-16-2002 12:23 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem Excel - Selection range problem
Excel - Selection range problem
Excel - Selection range problem
 
Excel - Selection range problem
Excel - Selection range problem
 
-->