So you want the cell addresses? If that's the case then
Selection.Address will do the trick.

-----Original Message-----
Hi all,

I am working on a little app to create a textfile based
on
user input. The idea is that the user can select a
certain
part of the active sheet that needs to be saved to a
textfile in a fixed-length format. However, I have not
been able to 'read' the selection. So my question,
probably quite easy to solve, is: how can I retreive the
columns and rows in the active selection? Kind of like
Selection.PrintOut, except I need f.a. A4:E25 instead of
Selection because I use a custom function to write the
contents to file.

Many thanks in advance for any helpful replies.


With kind regards,

Ivo.
.