Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

select certain cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
melle - 05 Sep 2005 13:44 GMT
I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025

So, I want to select A1 + 4.

I would be very thankful if someone could help me.

Ragards,

Melle

Signature

melle

Don Guillett - 05 Sep 2005 14:18 GMT
a bit more detail might help

Signature

Don Guillett
SalesAid Software
donaldb@281.com

>
> I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025
[quoted text clipped - 6 lines]
>
> Melle
Dave Peterson - 05 Sep 2005 14:36 GMT
Manually?

One way...

Insert a new column (say E??)
Put this in E1:
=mod(row(),4)
drag down as far as you need to go

Now apply Data|Filter|Autofilter to column E.
Filter to show only the 1's
Then select column A
Edit|goto|special|visible cells only

then either remove the autofilter or just turn it off:
data|filter|autofilter
or
data|filter|show all

You can delete that helper column later.

> I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025
>
[quoted text clipped - 11 lines]
> melle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26981
> View this thread: http://www.excelforum.com/showthread.php?threadid=401913

Signature

Dave Peterson

gearoi - 05 Sep 2005 14:37 GMT
sure hold down ctrl and select the cells in question.

You might want to code it I suppose in which case you do:

range("your_range").resize(4,1).select

I'm not sure how much more I can help without more info
Bruno Campanini - 05 Sep 2005 21:42 GMT
> I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025

So you want to select 1007 cells; simultaneously or sequentially?

Bruno
Bruno Campanini - 06 Sep 2005 00:07 GMT
> I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025
>
> So, I want to select A1 + 4.
>
> I would be very thankful if someone could help me.

This selects simultaneously 1007 cells as requested
------------------------------------------------
Sub BigSelection()
Dim i As Integer, NumArray(1 To 1008) As Integer
Dim j As Integer, BigRange(1 To 28) As String
Dim VeryBigRange As Range
For i = 1 To 4029 Step 4
   j = j + 1
   NumArray(j) = i
Next
For i = 1 To 28
   For j = 1 To 36
       BigRange(i) = BigRange(i) & "A" & NumArray(j + 36 * (i - 1)) & ","
   Next
   Mid(BigRange(i), Len(BigRange(i)), 1) = " "
Next
BigRange(i - 1) = Mid(BigRange(i - 1), 1, Len(BigRange(i - 1)) - 7)
Set VeryBigRange = Application.Union( _
Range(BigRange(1)), Range(BigRange(2)), Range(BigRange(3)),
Range(BigRange(4)), _
Range(BigRange(5)), Range(BigRange(6)), Range(BigRange(7)),
Range(BigRange(8)), _
Range(BigRange(9)), Range(BigRange(10)), Range(BigRange(11)),
Range(BigRange(12)), _
Range(BigRange(13)), Range(BigRange(14)), Range(BigRange(15)),
Range(BigRange(16)), _
Range(BigRange(17)), Range(BigRange(18)), Range(BigRange(19)),
Range(BigRange(20)), _
Range(BigRange(21)), Range(BigRange(22)), Range(BigRange(23)),
Range(BigRange(24)), _
Range(BigRange(25)), Range(BigRange(26)), Range(BigRange(27)),
Range(BigRange(28)))
VeryBigRange.Select
End Sub
---------------------------------------------

Ciao
Bruno
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.