Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default activating cells

Hi,

I have an active selected cell in a worksheet. I want to be able to select
the cell that's three rows down. How can I address that cell so I can modify
it?

Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default activating cells

Hi Ryan,

One way:

Dim rng as Range
Set rng = Activecell.offset(3)

---
Regards,
Norman


"Ryan H." wrote in message
. rogers.com...
Hi,

I have an active selected cell in a worksheet. I want to be able to select
the cell that's three rows down. How can I address that cell so I can

modify
it?

Thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating cells with checkbox KeyAdministration Excel Worksheet Functions 1 May 30th 08 02:14 PM
Dynamically Activating Cells Rob Excel Discussion (Misc queries) 5 June 5th 07 04:39 PM
Exception in Activating Subscription Cells Ostate Excel Discussion (Misc queries) 1 May 22nd 07 07:38 AM
Exception in Activating Subscription cells Ostate Excel Discussion (Misc queries) 0 May 19th 07 05:56 PM
Activating VB form by changing cells CTInt04 Excel Programming 3 June 30th 04 12:13 AM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"