Re: Deselect a range?
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Sun, 21 Jan 2007 09:19:45 -0600
You didn't say where to copy to but try this ONE liner. Change to suit.
Sub copyTextColumnA()
Range("A2:a" & Cells(2, "a").End(xlDown).Row).Copy Range("i19")
End Sub
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
news:g607r251ceedk6ad3ea8nd8bt0oeehvlab@xxxxxxxxxx
This one has been asked many times before, I see from the archives.
But I can't get anything recommended to work.
Here is the code:
************************************************************************************
Sub SelectTextColumnA()
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
End Sub
************************************************************************************
If I select something else, as recommended, that doesn't get rid of
tghe marching ants.
If I set the cuut/copy mode to false, as also recommended, the text
isn't in the clipboard so it nullifies the code:
Application.CutCopyMode = False
In fact, any of the other recommendations tried do that. The text is
no longer in the clipboard so the whole macro doesn't work. Is there
a way to get the text into the clipboard yet de-select the range?
I've tried so much from the archives this morning and nothing works so
appreciate any help.
.
- Follow-Ups:
- Re: Deselect a range?
- From: Don Guillett
- Re: Deselect a range?
- References:
- Deselect a range?
- From: StargateFan
- Deselect a range?
- Prev by Date: Re: Selecting Next Worksheet
- Next by Date: RE: Display Value In Form's Textbox
- Previous by thread: Deselect a range?
- Next by thread: Re: Deselect a range?
- Index(es):
Relevant Pages
|
