Solved

VBA Excel 2000 - Range selection with Cells

Posted on 2011-02-22
2
373 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

816 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

8 Experts available now in Live!

Get 1:1 Help Now