Select range of cells using VBA

[swati29]

Hi All,

I am looking to select range of cells in excel 2007 using VBA macros based on the cell value .for eg:

Based on cell value (3 or 2) select the rows (shown with red color font)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cell Value
[/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]
Kindly help!

Thanks,
Swati

 

[sanrv1f]

Hi Swati

Welcome to the Forum

Few questions,
- does the value in first column decides the number of cells to be selected in that row?
- what is that you intend to do after selecting the cells?