Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells
Excel - looping through selected cells Excel - looping through selected cells
Excel - looping through selected cells
Go Back  Xtreme Visual Basic Talk > > > Excel - looping through selected cells


Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2012, 05:48 AM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default Excel - looping through selected cells


Hi everyone, I'm trying to find a way of finding selected cell or rows in my vb2008 code, I can loop through and read all the cells in my code, but I can't seem to find out if it's selected or not. The senario is, I want to go down the sheet manually and holding the CTRL key down click on each cell of interest, highlighting it, then using my code work out which cell was highlighted and store it's location in an array something like :-

Code:
for x = 1 to xlapp.rowcount
 if xlapp.range(x) = selected then ......
next x
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
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

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 - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells Excel - looping through selected cells
Excel - looping through selected cells
Excel - looping through selected cells
 
Excel - looping through selected cells
Excel - looping through selected cells
 
-->