Posted to microsoft.public.excel.programming

external usenet poster

Posts: 12

Excel VB issue

I am checking a cell to see if it is blank or populated. For some reason it
is not recognizing my "if" statement that = "" or <"". Below is the code:

If Range("B13").Formula = """" Then
Range("A12:A23").Select
Selection.Copy
Sheets("DetailFinal").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Sheets("Worksheet").Select
End If

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel issue	pierre	Excel Discussion (Misc queries)	2	April 8th 08 04:15 PM
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same	Melsh	Excel Discussion (Misc queries)	0	August 1st 07 09:32 PM
Excel issue	noor	Excel Discussion (Misc queries)	1	January 9th 06 08:32 PM
Odd issue with Excel 97 SR-2	Gordon	Excel Discussion (Misc queries)	3	February 10th 05 08:52 PM
Excel 2003 Issue with UsedRange.Copy (code works in Excel 2002)	TechFirm	Excel Programming	4	January 21st 05 01:53 AM

All times are GMT +1. The time now is 06:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us