Solved

offset entire range

Posted on 2012-04-02
2
242 Views
Last Modified: 2012-04-02
Hi,

What is the Syntax for Offsetting 18 columns across and then till the end of the rows. But i need the entire selection selected.

Normally i would say
 Range(Selection, Selection.End(xlToRight)).Select
 Range(Selection, Selection.End(xlDown)).Select

But there is gaps in the data, so i need to specifically say 18 Columns to the right and down to end.

Thanks
Seamus
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
Comment Utility
I'm guessing you mean:

Range(Selection, Selection.Offset(0, 18).End(xlDown)).Select

Open in new window


but there is rarely any need to select anything.

Depending on the layout, you may also be able to use:

Selection.CurrentRegion.Select

Open in new window

0
 

Author Closing Comment

by:Seamus2626
Comment Utility
Range(Selection, Selection.Offset(0, 18).End(xlDown)).Select

That works perfectly for me Rory, just need to clear some errors and this is the quickest way to do it.

Thanks
Seamus
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
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.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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 …

744 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

17 Experts available now in Live!

Get 1:1 Help Now