Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cell Contents from multippel cells
I am confused with your request. Are you wanting to hide these other sheets
and only show your MAIN sheet? "Yngve" wrote in message ... Help needed I have 4 sheets, one is mane sheet, on the main sheet I have this formula =sheet2!A1 & sheet3!A1& sheet4!A1 A1 contains text like this AD,DFR,UFF, some of letters have Font,CollorNumber 3 and I want this to show in the main sheet. Is it possible ??? I've exhausted all the online help files I can find with no results. Regard Yngve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cell Contents from multippel cells
You need to use somethinglikethis:-
Sub ColorMeInThree() 'Concatenate [A1].Select ActiveCell.Value = Sheets("Sheet2").Range("A1") & _ Sheets("Sheet3").Range("A1") & _ Sheets("Sheet4").Range("A1") 'Colors a = Sheets("Sheet2").Range("A1").Font.ColorIndex b = Sheets("Sheet3").Range("A1").Font.ColorIndex c = Sheets("Sheet4").Range("A1").Font.ColorIndex 'Lengths d = Len(Sheets("Sheet2").Range("A1")) e = Len(Sheets("Sheet2").Range("A1")) f = Len(Sheets("Sheet2").Range("A1")) ActiveCell.Characters(1, d).Font.ColorIndex = a ActiveCell.Characters(d + 1, d + e).Font.ColorIndex = b ActiveCell.Characters(d + e + 1, d + e + f).Font.ColorIndex = c End Sub http://www.excel-ant.co.uk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cell Contents from multippel cells
Hi Mark
Tanks for replay I dont want to hide sheets. I want to show in main sheet i.e if sheet2!A1 value = AD,DFR<--- font.collor black, UFF<----font.collor red and if sheet3!A1 value = AD,DFR<--- font.collor red,UFF<----font.collor black then main sheet1!A1 shows exactly the same. "main sheet1!A1 = from sheet2( AD,DFR<--- font.collor red,UFF<----font.collor black,) + = from sheet3( AD,DFR<--- font.collor red,UFF<----font.collor black,) " hope this explain better what I need. Regard Yngve "Mark Ivey" wrote: I am confused with your request. Are you wanting to hide these other sheets and only show your MAIN sheet? "Yngve" wrote in message ... Help needed I have 4 sheets, one is mane sheet, on the main sheet I have this formula =sheet2!A1 & sheet3!A1& sheet4!A1 A1 contains text like this AD,DFR,UFF, some of letters have Font,CollorNumber 3 and I want this to show in the main sheet. Is it possible ??? I've exhausted all the online help files I can find with no results. Regard Yngve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select the contents of a cell | Excel Programming | |||
select contents of cell | Excel Programming | |||
select a cell based on A1 contents | Excel Programming | |||
How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
How do I select a whole range and delete the contents of the cells? | Excel Programming |