Auto Highlight Code
 

Hey Crew.

I made a really sexy macro with the Help of Dave (forum person). Now
this macro saves my information to .csv format, But what im looking for
is the code which i can add to this macro that will only select the
cells i wish. e.g. cell "N11 down to "W35".

So anyone know any auto select code??? Spanks for your help


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=568179

Auto Highlight Code
 

Range("N11:W35).Select

Note: you rarely have to use select.

Instead of

Dim actSht As Worksheet
Set actSht = ActiveSheet
Worksheets("Sheet2").Activate
Range("A1:J10").Select
Selection.Copy
actSht.Activate
Range("K43").Select
ActiveSheet.Paste

use

Worksheets("Sheet2").Range("A1:J10").Copy _
Destination:=ActiveSheet.Range("K43")

or, if you just want to copy values:

Range("K43").Resize(10, 10).Value = _
Worksheets("Sheet2").Range("A1:J10").Value

which bypasses using the Clipboard (and is analogous to Paste
Special/Values)


Gord Dibben MS Excel MVP



On Thu, 3 Aug 2006 20:58:46 -0400, joelbeveridge
wrote:


Hey Crew.

I made a really sexy macro with the Help of Dave (forum person). Now
this macro saves my information to .csv format, But what im looking for
is the code which i can add to this macro that will only select the
cells i wish. e.g. cell "N11 down to "W35".

So anyone know any auto select code??? Spanks for your help

Auto Highlight Code
 

Check your other thread.

joelbeveridge wrote:

Hey Crew.

I made a really sexy macro with the Help of Dave (forum person). Now
this macro saves my information to .csv format, But what im looking for
is the code which i can add to this macro that will only select the
cells i wish. e.g. cell "N11 down to "W35".

So anyone know any auto select code??? Spanks for your help

--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=568179

--

Dave Peterson