Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 20th, 2007, 11:22 AM
Authorized User
 
Join Date: Jul 2007
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Column color issue

When I color one particular column using fill color on the menu it does, but when I copy data from another column and paste it in previous column (which was blue) then color changed to a new one. Is there way I can do it permanently even user copy and paste data from other column.
Thank you so much for looking.

Reply With Quote
  #2 (permalink)  
Old August 21st, 2007, 05:05 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Hampshire, United Kingdom.
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

Zone,

Best way to find out what the code for stuff like this is to find out how to do it manually, then do it again with record macros, when I first got into Excel VBA I did it loads and you'll be suprised how efficient Excel is some times, and inefficient in others. But it will always point you in the right direction.

As a pointer, "Edit > "Paste Special" > OK... ;)

Best Regards,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".

Thomas Jefferson</center>
Reply With Quote
  #3 (permalink)  
Old August 21st, 2007, 09:03 AM
Authorized User
 
Join Date: Jul 2007
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your feedback. I curious what do you mean by “find out what the code for stuff like this is to find out how to do it manually” I was kinda looking some way of doing this using macro and VBA, but I am not sure how to.
All I like to put any color (blue/red/green etc) in a column using VBA code
Reply With Quote
  #4 (permalink)  
Old August 21st, 2007, 09:40 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Hampshire, United Kingdom.
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

Zone,

Yes, what I am saying, is that you know how to perform the action yourself, right?
So hit the Macro "Record" Button (Tools > Macro > Record New Macro) and do it. Then view the resultant
code generated by Access/Excel for some ideas on how to do it.

I am not saying I dont want to help you, I am tryin to show you one of the best ways to learn how to do this yourself.

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".

Thomas Jefferson</center>
Reply With Quote
  #5 (permalink)  
Old September 4th, 2007, 11:59 AM
Authorized User
 
Join Date: Jul 2007
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I understood that. That was not what I meant.
Thanks for your feedback.
Cheers


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bitmap color-depth issue warlock7 Visual C++ 2005 0 July 25th, 2007 12:55 PM
Column of a Grid Gray in Color shailesh_kumar Beginning VB 6 4 April 27th, 2007 12:59 PM
How to change the color of list control's column gemini Visual C++ 1 August 28th, 2006 12:58 AM
Identity Column Issue mepancha SQL Server 2000 5 June 17th, 2005 03:00 PM
Datagrid newrow column color sa5webber General .NET 0 May 17th, 2004 05:47 AM



All times are GMT -4. The time now is 05:58 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.