How to use VBA to drag down ?

Select an empty cell.
edit|copy
select column A
edit|Paste special|check addition

If you need this in your macro, record a macro and you'll see useable code.

vumian wrote:
>
> Oke, ths, it runs well.
>
> i also get one small thing more, pls help me
>
> Col A stores Number as Text
> How to convert it to end of 'Number as Text' ,
> row 1- title is present a real text.
>
> thanks for your help.
>
> --
> vumian
> ------------------------------------------------------------------------
> vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
> View this thread: http://www.excelforum.com/showthread...hreadid=563001

--

Dave Peterson

oh,i've not ever thought it before,) so great great, you're good man , :P
thank you very much.

I think it's so cool that you help others whose first language is not
English. Way to go Dave. Yes, you are a good man. I agree with vumian.
--
Chris

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44BFA9E4.94EBDFB7@verizonXSPAM.net...
| Select an empty cell.
| edit|copy
| select column A
| edit|Paste special|check addition
|
| If you need this in your macro, record a macro and you'll see useable
code.
|
| vumian wrote:
| >
| > Oke, ths, it runs well.
| >
| > i also get one small thing more, pls help me
| >
| > Col A stores Number as Text
| > How to convert it to end of 'Number as Text' ,
| > row 1- title is present a real text.
| >
| > thanks for your help.
| >
| > --
| > vumian
| > ------------------------------------------------------------------------
| > vumian's Profile:
http://www.excelforum.com/member.php...o&userid=36494
| > View this thread:
http://www.excelforum.com/showthread...hreadid=563001
|
| --
|
| Dave Peterson

There are lots of people in these groups that help people--no matter what the
OP's mother tongue is--be it English, VBA or even binary <vbg>.


Chris wrote:
>
> I think it's so cool that you help others whose first language is not
> English. Way to go Dave. Yes, you are a good man. I agree with vumian.
> --
> Chris
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44BFA9E4.94EBDFB7@verizonXSPAM.net...
> | Select an empty cell.
> | edit|copy
> | select column A
> | edit|Paste special|check addition
> |
> | If you need this in your macro, record a macro and you'll see useable
> code.
> |
> | vumian wrote:
> | >
> | > Oke, ths, it runs well.
> | >
> | > i also get one small thing more, pls help me
> | >
> | > Col A stores Number as Text
> | > How to convert it to end of 'Number as Text' ,
> | > row 1- title is present a real text.
> | >
> | > thanks for your help.
> | >
> | > --
> | > vumian
> | > ------------------------------------------------------------------------
> | > vumian's Profile:
> http://www.excelforum.com/member.php...o&userid=36494
> | > View this thread:
> http://www.excelforum.com/showthread...hreadid=563001
> |
> | --
> |
> | Dave Peterson

--

Dave Peterson