How to use VBA to drag down

  • Thread starter Thread starter vumian
  • Start date Start date
V

vumian

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
 
Range("C1").AutoFill Destination:=Range("C1:C10"), Type:=xlFillDefault

HTH

Die_another_Day
 
You have another response at your other thread.
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 .
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use VBA to drag down ? 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
VBA to run all variable combinations in a calculation model and store result 6
Dynamically create drop down box when cell value changes 2
Fill both cells if one cell has a negative amount 2
Sheet Cleanup Help Please 5
Column number of last column that returns value ignore formulas 8

Back
Top