highlight the row of the cell Im working in?
in [General]
|
From: Gord Dibben on 2 Apr 2010 16:30 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 2 Apr 2010 17:21 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 2 Apr 2010 17:28 ....and if I may add - try it in a fresh new WB. Micky "מיכאל (מיקי) אבידן" 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: Gord Dibben on 3 Apr 2010 09:53 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 13:10 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
|
Next
|
Last
Pages: 1 2 3 Prev: Name a worksheet tab based on the value in a cell. Next: PIVOT TABLE Help Please |