About Us

Gerry[_6_]

If C2 is blank then put value of B2 into C2 otherwise
leave C2 as it is. All data type are the same. Can anyone
help me with this please.

JE McGimpsey

One way:

With Range("C2")
If IsEmpty(.Value) Then .Value = .Offset(0, -1).Value
End With

In article ,
"Gerry" wrote:

If C2 is blank then put value of B2 into C2 otherwise
leave C2 as it is. All data type are the same. Can anyone
help me with this please.

Gerry[_6_]

Many Thanks for this.
Now I want to replicate this down the column.

Can you assist.

Gerry

-----Original Message-----
One way:

With Range("C2")
If IsEmpty(.Value) Then .Value = .Offset(0, -
1).Value
End With

In article ,
"Gerry" wrote:

If C2 is blank then put value of B2 into C2 otherwise
leave C2 as it is. All data type are the same. Can
anyone
help me with this please.
.

JE McGimpsey

One way:

Dim rCell As Range
For Each rCell in Range("C2:C" & _
Range("C" & Rows.Count).End(xlUp).Row)
With rCell
If IsEmpty(.Value) Then .Value = .Offset(0, 1).Value
End With
Next rCell

In article ,
"Gerry" wrote:

Many Thanks for this.
Now I want to replicate this down the column.

Can you assist.

Gerry

-----Original Message-----
One way:

With Range("C2")
If IsEmpty(.Value) Then .Value = .Offset(0, -
1).Value
End With

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding descrete valuse	Steve M	Excel Worksheet Functions	3	October 25th 06 04:49 PM
How to find valuse in cells.	kodzirko	Excel Worksheet Functions	1	July 6th 06 12:27 PM
excluding valuse from an average	toot033	Excel Discussion (Misc queries)	2	April 11th 06 01:41 PM
Selecting valuse from a table	Dave	Excel Discussion (Misc queries)	2	September 16th 05 05:28 AM
Insert a value based on unique valuse in a row	John Fevens	Excel Programming	2	January 30th 04 05:04 PM

Menu

About Us