Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste and highlight the cells of range
Experts,
I have a range to copy and paste. The range to copy varies with a variable value. While defining the target range, I just give reference to first cell of the column where it has to start pasting. For example, If I want to copy values in cells A1:A10 in the the column B, I use rng_source.Copy 'range A1:A10, it varies with input given rng_target.PasteSpecial Paste:=xlPasteValues 'range points at first cell of target, here it is B1 rng__target.Interior.ColorIndex = 5 'setting the color for the cells copied These steps just highlight the first cell of target and not the entire range. I want the whole range from B1 to B10 to be highlighted. Is there any way to do it? Har**** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy/paste won't refer to the appropriate range of cells | Excel Discussion (Misc queries) | |||
How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
want highlight when all cells in range are equal | Excel Worksheet Functions | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
How to paste INDIRECT function to range of cells? | Excel Worksheet Functions |