highlight the row of the cell Im working in?
in [General]
|
From: Gord Dibben on 3 Apr 2010 14:17 I guess I do not understand why you brought up the subject of copy/pasting when OP asked for highlighting/coloring the row he was working on. Other codes are not designed to copy/paste. Gord On Sat, 3 Apr 2010 10:10:01 -0700, ????? (????) ????? <micky-a*at*tapuz.co.il> wrote: >Well..., I never claimed it won't. >However - my code copies 3,4,... 256 cells [full row, in "2003"] while the >other codes do not. >I suppose it is easier to delete unnecessary data rather than type it. >Micky > > >"Gord Dibben" wrote: > >> Funny as in odd. >> >> Yes, I checked your code. >> >> Any cell I wish to copy brings the entire row with it. >> >> >> Gord >> >> >> >> On Fri, 2 Apr 2010 14:21:02 -0700, ????? (????) ????? >> <micky-a*at*tapuz.co.il> wrote: >> >> >I assume that funny is a relative term... >> >Did you check my code ? >> >1) In the VBE, copy the code to a Worksheet(!) level. >> >2) Click to select cell D5. >> >3) Type 123 and press CTRL+C. >> >4) Move - with an arrow key - to Cell D6 and press CTRL+V. >> >[In both cases the entire row, 5 and then 6 will be Highlighted as light gray] >> >*** What did you get ? *** >> >Micky >> > >> > >> >"Gord Dibben" wrote: >> > >> >> Micky >> >> >> >> Funny you should mention facing problems with copy/paste with some of the >> >> codes. >> >> >> >> Have you actually tried your own code? >> >> >> >> How would you suggest copying and pasting a range of of cells when entire >> >> rows are selected? >> >> >> >> >> >> >> >> Gord >> >> >> >> >> >> On Fri, 2 Apr 2010 12:42:01 -0700, ????? (????) ????? >> >> <micky-a*at*tapuz.co.il> wrote: >> >> >> >> >If you'll face any problems when trying to COPY/PASTE with some of the codes >> >> >- I would suggest not to color the Row but, instead, to Highlight it only . >> >> >Try the following code: >> >> >------------------------------------------------------------------------------------ >> >> >Private Sub Worksheet_SelectionChange(ByVal Target As Range) >> >> > Target.EntireRow.Select >> >> > Target.Activate >> >> >End Sub >> >> >--------------- >> >> >Micky >> >> > >> >> > >> >> >"mock" wrote: >> >> > >> >> >> I am dealing with a lot of data and I ma trying to highlight the row of the >> >> >> cell I am currently working on. Any suggestions that Excel 2007 can perform >> >> >> with out add-ons? >> >> >> >> . >> >> >> >> . >>
From: מיכאל (מיקי) אבידן on 3 Apr 2010 15:46 ....because an average Excel user would need to copy/paste from time to time - don't you think so... By the way, if an OP asks/mentions only the need for highlighting, the entire row, does it prove he is willing to given up all other Build-in "Excel" features. Would you, or one of your acquaintances, prefer highlighting an entire row by giving up the Copy/Paste feature !? Frankly, I don't see any reason to keep this superfluous argument going on - so, please consider this as my last reply in this thread... Have a nice weekend, Micky "Gord Dibben" wrote: > I guess I do not understand why you brought up the subject of copy/pasting > when OP asked for highlighting/coloring the row he was working on. > > Other codes are not designed to copy/paste. > > > Gord > > On Sat, 3 Apr 2010 10:10:01 -0700, ????? (????) ????? > <micky-a*at*tapuz.co.il> wrote: > > >Well..., I never claimed it won't. > >However - my code copies 3,4,... 256 cells [full row, in "2003"] while the > >other codes do not. > >I suppose it is easier to delete unnecessary data rather than type it. > >Micky > > > > > >"Gord Dibben" wrote: > > > >> Funny as in odd. > >> > >> Yes, I checked your code. > >> > >> Any cell I wish to copy brings the entire row with it. > >> > >> > >> Gord > >> > >> > >> > >> On Fri, 2 Apr 2010 14:21:02 -0700, ????? (????) ????? > >> <micky-a*at*tapuz.co.il> wrote: > >> > >> >I assume that funny is a relative term... > >> >Did you check my code ? > >> >1) In the VBE, copy the code to a Worksheet(!) level. > >> >2) Click to select cell D5. > >> >3) Type 123 and press CTRL+C. > >> >4) Move - with an arrow key - to Cell D6 and press CTRL+V. > >> >[In both cases the entire row, 5 and then 6 will be Highlighted as light gray] > >> >*** What did you get ? *** > >> >Micky > >> > > >> > > >> >"Gord Dibben" wrote: > >> > > >> >> Micky > >> >> > >> >> Funny you should mention facing problems with copy/paste with some of the > >> >> codes. > >> >> > >> >> Have you actually tried your own code? > >> >> > >> >> How would you suggest copying and pasting a range of of cells when entire > >> >> rows are selected? > >> >> > >> >> > >> >> > >> >> Gord > >> >> > >> >> > >> >> On Fri, 2 Apr 2010 12:42:01 -0700, ????? (????) ????? > >> >> <micky-a*at*tapuz.co.il> wrote: > >> >> > >> >> >If you'll face any problems when trying to COPY/PASTE with some of the codes > >> >> >- I would suggest not to color the Row but, instead, to Highlight it only . > >> >> >Try the following code: > >> >> >------------------------------------------------------------------------------------ > >> >> >Private Sub Worksheet_SelectionChange(ByVal Target As Range) > >> >> > Target.EntireRow.Select > >> >> > Target.Activate > >> >> >End Sub > >> >> >--------------- > >> >> >Micky > >> >> > > >> >> > > >> >> >"mock" wrote: > >> >> > > >> >> >> I am dealing with a lot of data and I ma trying to highlight the row of the > >> >> >> cell I am currently working on. Any suggestions that Excel 2007 can perform > >> >> >> with out add-ons? > >> >> > >> >> . > >> >> > >> > >> . > >> > > . >
First
|
Prev
|
Pages: 1 2 3 Prev: Name a worksheet tab based on the value in a cell. Next: PIVOT TABLE Help Please |