Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to use VBA to drag down


i have 3 col
- fisrt and second col contain value (exiset already)
- Minus them will be contain third col


How to :
use VBA to minus an drag down end of row of col 1 or 2

Thanks for your help

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=56299

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 644
Default How to use VBA to drag down

Range("C1").AutoFill Destination:=Range("C1:C10"), Type:=xlFillDefault

HTH

Die_another_Day
vumian wrote:
i have 3 col
- fisrt and second col contain value (exiset already)
- Minus them will be contain third col


How to :
use VBA to minus an drag down end of row of col 1 or 2

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=562999


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default How to use VBA to drag down

You have another response at your other thread.

vumian wrote:

i have 3 col
- fisrt and second col contain value (exiset already)
- Minus them will be contain third col

How to :
use VBA to minus an drag down end of row of col 1 or 2

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=562999


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UNABLE TO DRAG THE VALUE? UNABLE TO DRAG THE VALUE? Excel Worksheet Functions 1 May 19th 10 09:05 PM
drag down Tami Excel Worksheet Functions 6 September 20th 09 04:49 PM
Autofilter & Drag. GEM Excel Discussion (Misc queries) 2 August 25th 09 04:23 PM
drag..... Ankur Excel Discussion (Misc queries) 2 August 22nd 05 09:25 AM
Drag & Drop !? RAFAAJ2000[_2_] Excel Programming 0 July 27th 05 02:57 PM


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"