| View previous topic :: View next topic |
| Author |
Message |
topher
General User
Joined: 29 Sep 2004
Posts: 12
|
 Posted: Fri Oct 01, 2004 10:25 pm Post subject: [b]HELP. URGENT![/b] HOW TO COPY CELL RANGE................. |
 |
|
Can anyone give me a sample code on how to copy cell range from one sheet to another but getting only the string component (avoiding the formula)?
T.Y. |
|
| Back to top |
|
 |
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Mon Oct 04, 2004 6:45 pm Post subject: Re: [b]HELP. URGENT![/b] HOW TO COPY CELL RANGE............. |
|
|
| topher wrote: | Can anyone give me a sample code on how to copy cell range from one sheet to another but getting only the string component (avoiding the formula)?
T.Y. |
Try recording a macro: copy then paste to next sheet using Paste Special (check only strings and values).
_________________
# : - ) |
|
| Back to top |
|
|
wahur
Power User
Joined: 22 Sep 2004
Posts: 62
Location: Tallinn, Estonia
|
| Posted: Wed Oct 06, 2004 5:00 am Post subject: |
|
|
http://www.pitonyak.org/AndrewMacro.sxw
is an excellent document to learn about macros. It also has example code there that does exactly what you ask for.
Wahur, just used the same example |
|
| Back to top |
|
|
|
