I need help in writing this macro
if the cell content is empty fill it with Red
if cell content contains "Y" then fill it with Yellow
if no "Y" and any content then fill it with Green
thanks...its urgent
--~--~-~--~~~---~--~~
-
Hello all,
Can somebody help me in implementation of importing the excel data to
datagridView in visualbasic 2005
How can this be done ??
Thank you
--~--~-~--~~~---~--~~
-
Some impo
MsgBox Cells(i, j).Value
> End If
> Next
> Next
>
> End Sub
>
> On Fri, Mar 27, 2009 at 6:34 AM, xxx wrote:
>
> > I have a excel table as below
>
> > Xxx 1 5
> > Yyy Fgf Dfd
> > Zzz
I have a excel table as below
Xxx 1 5
Yyy Fgf Dfd
Zzz dfg Dsgf
qqq 4 fg dfg
i need to get all the values of occupied cells in every row...
so in the 1st row...i need to get the values
xxx
1 and 5 excluding space in 3rd column
,Cells(R,100))
>
>
>
> ____
> From: xxx
> To: MS EXCEL AND VBA MACROS
> Sent: Wednesday, March 25, 2009 5:58:55 AM
> Subject: $$Excel-Macros$$ count number of occupied cells in every row
>
> Hi all,
> I need some help since i an beginner in vba programming
&g
Hi all,
I need some help since i an beginner in vba programming
I have say an excel table as below:
1 2 3 4 5
2 3 4 5 6 6 78 8 9
hdg dg gdh gj
fsf
sf sfs sfs sf
in this table I have to count number of occupied cells in every row
in first row the result should be 5
In second row: 9
third row: 4
