'If' syntax

**hvisa** · 01-30-2007, 12:26 PM

Is it possible to use IF( a2=5) then select a range of cells.
if yes, what is the syntax.

Thanks

**EdMac** · 01-30-2007, 01:00 PM

Hi

=if(a2=5,do_this,else_do_that)

HTH

Ed

**VBA Noob** · 01-30-2007, 02:00 PM

Hi,

Just to add if condtion return text add quote marks. Numbers don't require quote marks

E.g

=if(a2=5,"do_this","else_do_that")

VBA Noob

**hvisa** · 01-30-2007, 04:13 PM

I think I explained it wrong. Sorry.
Is it possible to use in a IF statement , if the condition is true, then copy range of cells.
Is it possible to do copy a range of cells say D2:D5 if the condition is true.

Thanks

**VBA Noob** · 01-30-2007, 04:33 PM

Hi,

You can use an event macro.

Right click sheet name and select view code. Paste below into sheet.

This will copy your range if A1 = true.

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("A1").Value = True Then
Range("D2:D5").Copy
End If

End Sub

Replace the bold line above if you want to copy it to a new area e.g E2

Range("D2:D5").Copy Range("E2")

VBA Noob

'If' syntax

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

'If' syntax

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions