How to get the range of data in a sheet?

[sid_a]

Version: MS Excel 2008
Operating System: Mac OS X 10.4.11

I want to copy all the data of a sheet. For this i need to have the range of
data in sheet. I have tried get end range but its not working. If anyone can
help me out.

Thanks!

 

[Bob Greenblatt]

Version: MS Excel 2008
Operating System: Mac OS X 10.4.11

I want to copy all the data of a sheet. For this i need to have the range of
data in sheet. I have tried get end range but its not working. If anyone can
help me out.

Thanks!

We can't read your mind. What are you trying to do, and how are you trying
it? Why do you "need to have the range..."?

 

[r_poetic]

Version: MS Excel 2008
Operating System: Mac OS X 10.4.11

I want to copy all the data of a sheet. For this i need to have the rangeof
data in sheet. I have tried get end range but its not working. If anyone can
help me out.

Thanks!

If you simply want to select everything on a sheet, click on the
little box in the upper left corner. Then copy that.

 

[CyberTaz]

Here's another thought if the content's going to the same or another open XL
book- Why not just Control/Right-Click the sheet tab & use Move or Copy
Sheet? If you intend to paste it elsewhere, select the top-left-most cell
then key SHIFT+COMMAND+END [if using a laptop you'll need to include fn].

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[sid_a via MacKB.com]

Hi!

I want to do this in Applescript. Actually here is the VBA code that I want
to convert to Applescript code.

Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

Here's another thought if the content's going to the same or another open XL
book- Why not just Control/Right-Click the sheet tab & use Move or Copy
Sheet? If you intend to paste it elsewhere, select the top-left-most cell
then key SHIFT+COMMAND+END [if using a laptop you'll need to include fn].

HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: MS Excel 2008
Operating System: Mac OS X 10.4.11

[quoted text clipped - 4 lines]

Thanks!

 

[r_poetic]

Hi!

I want to do this in Applescript. Actually here is the VBA code that I want
to convert to Applescript code.

Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

Here's another thought if the content's going to the same or another open XL
book- Why not just Control/Right-Click the sheet tab & use Move or Copy
Sheet? If you intend to paste it elsewhere, select the top-left-most cell
then key SHIFT+COMMAND+END [if using a laptop you'll need to include fn]..

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 10/20/08 2:26 AM, in article 8bef71105f418@uwe, "sid_a" <u47019@uwe>
wrote:

Version: MS Excel 2008
Operating System: Mac OS X 10.4.11

[quoted text clipped - 4 lines]

Thanks!

While you could write something parallel to your vba code, try this
cool command instead:

get used range of theWorksheet

(or the active sheet, or however you name the sheet in hand)

RS