Solved

VBA Excel 2000 - Range selection with Cells

Posted on 2011-02-22
2
371 Views
Last Modified: 2012-05-11
Dear Experts,

I am searching an alternative for this simple row in VBA so selecting a certain range

Range("A11:G18").Select

Could be done somehow this with applying Cells?

So for example the Cells(11, 1).Select selects the A11, but could be such applied to selecting an area until Cells(11,7) ?

thanks,
0
Comment
Question by:csehz
2 Comments
 
LVL 2

Accepted Solution

by:
jo_m earned 500 total points
ID: 34951630

hello there

 if you are  starting at A1  then you could use

Range("A1").offset(11,7).select

 this will select all from the start cell Address to your final cell address


 I hope this is what you are looking for

tx

jo
0
 
LVL 1

Author Comment

by:csehz
ID: 34951683
Jo thanks yes you are right, I could do it with offset.

Basically I would like to put variable like offset(11," & Something & ").
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now