Solved

Copying a cell value down a column.

Posted on 2014-10-29
3
65 Views
Last Modified: 2014-10-29
Why would this produce a 1,2,3.... down the column instead of a 01,01,01,01??  I need a value specifically of "01" but it is not copying it down?  Any ideas?  I have tried just every cell format I can find?  Can this be done without using Autofill?

    Range("J3").Select
    ActiveCell.FormulaR1C1 = "01"
'Copies the formula in J3 down column J, as long as there is a value in columnG
    Set MyRange = Range(Range("J3"), Range("J" & Range("G3").End(xlDown).Row))
    Range("J3").AutoFill Destination:=MyRange

Open in new window

0
Comment
Question by:RWayneH
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
Comment Utility
Easier to just use:
myRange.Value = "'01"

Open in new window

0
 

Author Closing Comment

by:RWayneH
Comment Utility
Yup worked great.  Thanks.
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
Comment Utility
Rory you are very fast :-)


until i open the question, i see it is answered on the fly :-)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now