Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find out what the user selected?
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find out how many rows I have selected? | Excel Discussion (Misc queries) | |||
Macro To Open a User selected File | Excel Worksheet Functions | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
How do I generate a total cost for user selected rows? | Excel Discussion (Misc queries) | |||
Dynamic Charting - User Selected Data Lines | Charts and Charting in Excel |