LinkBack URL
About LinkBacks
Hi
I have a value "3 of bc" in range A1
If i copy range a1 and fill down to A10
Then don't change the value. same text should be copy down
A1 = "3 of bc"
A2 = "3 of bc"
A3 = "3 of bc"
A4 = "3 of bc"
A5 = "3 of bc"
Thank you
Copy and fill down a numeric+text value but dont change numeric value
Hi
I have a value "3 of bc" in range A1
If i copy range a1 and fill down to A10
Then don't change the value. same text should be copy down
A1 = "3 of bc"
A2 = "3 of bc"
A3 = "3 of bc"
A4 = "3 of bc"
A5 = "3 of bc"
Thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
If you fill out A2 with the same, then go to A1, hold shift, click A2 and copy down it'll display the way you want. Are you looking for a formula to do a mass duplication of this or just those select cells (A1-A10)?
press and hold Ctrl key and drag down
Another way similar to sandy's.
Select A1:A10. Type "3 of bc" in cell A1. While pressing and hold Ctrl hit Enter. The entire range will populate.
Dave
Or just drag down the way you always do, go ahead and let them change.
But when you're done, a little popout box shows up on the bottom right, choose 'Copy Cells' insetad of 'Fill Series'
Thank you all of you
Its working as i need
I have one more query
If i fill down above value using vabż
In VBA, I wouldn't bother with the Fill function.
Similar to FlameRetireds suggestion..
Put the value in all cells at once.
Range("A1:A10").Value = Range("A1").Value
That would be like filling down A1 to A10
That's another cool way to do it. Thanks for the tip. Requires right mouse button drag.Originally Posted by Jonmo1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks