blue
On Oct 28, 1:02 am, RolfJ wrote:
> What do you mean by 'Any color?'
>
> On Oct 27, 6:01 am, Bajji wrote:
>
>
>
> > Hi Rolf,
>
> > Let me put an example:
>
> > 1. Assume sheet1 has some information from Cells ranging A1 : G20
> > 2. When I run the macro, it should pop user form with 2 input
What do you mean by 'Any color?'
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> asking for cell range (example A1 and C6) to colo
I am sorry, but I am still not quite clear. What do you now mean by
'any color'?
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> a
Hi
If I understood correctly what you are trying to do, I would suggest you to
use "RefEdit" control which you may find in the additional controls dialog
box in form toolbox. It will allow the user to select a range from the
worksheet.
then u can use the following code (supposing the name of the
Hi Rolf,
Let me put an example:
1. Assume sheet1 has some information from Cells ranging A1 : G20
2. When I run the macro, it should pop user form with 2 input fields
asking for cell range (example A1 and C6) to color
3. Based on the above cell ranges A1:C6, the macro should color(Any
color) the
I am sorry, but I don't understand what you mean. Please try again.
On Oct 24, 5:08 am, Bajji wrote:
> Hi Rolf,
> I need similar help, little different way
>
> When I run the Macro, user form should pop up allowing to put the
> array (a1: j10) details to color the rows
>
> Regards,
> Sri
>
> On
Hi Rolf,
I need similar help, little different way
When I run the Macro, user form should pop up allowing to put the
array (a1: j10) details to color the rows
Regards,
Sri
On Oct 24, 4:53 am, RolfJ wrote:
> I can't figure a way to do this by way of conditional formating, but I
> can offer some
HI Rolf,
Thanks for providing the solution.
I need similar help, but little different way.
When I run the macro, user form should
On Oct 24, 4:53 am, RolfJ wrote:
> I can't figure a way to do this by way of conditional formating, but I
> can offer some VBA code that would do the trick. Place
I can't figure a way to do this by way of conditional formating, but I
can offer some VBA code that would do the trick. Place the following
code into the a standard VBA module of your workbook:
Public Sub ColorTable()
Dim rRow As Range
For Each rRow In ActiveSheet.UsedRange.Rows
I
