|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 9th, 2005, 08:29 AM
|
|||
|
|||
Excel macro HELP!
Hi,
Can anyone please help me with excel macros? I have a variable range of cells containing data, and got stuck in defining the macro that can automatically highlight those cells. e.g. data range sometimes starts from cell B1 to cell C5, sometimes from B1 to C20, etc... Appreciate your help folks..
|
|
#2
January 21st, 2005, 09:27 AM
|
|||
|
|||
|
Excel macro HELP!
Here is an example to copy a range of values. The range depends on the <i>returned</i> variable.
Sheets("Raw Data").Select Range(Cells(2, 1), Cells(1 + returned, 2)).Select Selection.Copy Cells(1, 1).Select
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Excel macro HELP! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
