LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work

Hey fellows

I have struggled a while now and need your help.

I have two columns:
The left has several ranges (A6:A22;A24:A36 ...) with cells only with
value "K" or an "I"
It can only accept "K" or "I"

The right (B6:B22;B24:B36 ...) has a text as you like
It has to accept copy and paste from other worksheets and within it
self.

Solution/Problem ONE
- The format sweep away with paste action. I have tried with EnableControl
subs but paste doesn't work - maybe it's my one of my subs:
- "worksheet_activate"
- "ActiveSheet.Unprotect" ...causing it, what do you think?

Solution/Problem TWO
Conditional formatting can't solve it. It has to be relative references (?),
from Column B:B to column A:A because I don't want to use a For ... Step 1
.... Next sub because that is not nice to work with, if I combine it with a
Worksheet_Change sub.... stepping all the time...

Could you please help me...?
Thanks!!!


 
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
conditional format ref., diff work sheet djc Excel Worksheet Functions 2 January 19th 09 07:19 PM
Conditional format does not work for some cells Kees Vos Excel Worksheet Functions 2 December 6th 07 06:30 AM
Any solution in order to have union of format using Conditional Fo Frank Situmorang Excel Discussion (Misc queries) 12 November 1st 07 09:43 AM
Copy/Paste Conditional Format Paul Excel Discussion (Misc queries) 2 June 20th 07 10:13 AM
Copy & paste conditional format WCDoan New Users to Excel 2 July 27th 06 09:40 PM


All times are GMT +1. The time now is 07:27 AM.

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

About Us

"It's about Microsoft Excel"