LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Excel VBA Test For Blank Cell

Try this:

'If the length of the value in named range CNT is not zero
(there's something in it), do the deed. Otherwise do
nothing.
If Len(Range("CNT")) < 0 Then
Range("CNT").Offset(0, 5).Select
End If

-----Original Message-----
I'm new to this forum and believe I should have made my

initial post here, rather than under Applications.

I have a cell named, CNT. The possibility exists this

cell may contain either a label or a value. This cell
needs to be tested to determine whether it is a blank
cell. I
would like to use the ISBLANK function. Below are my

partially correct macro lines for doing this. I do not
know how to write the "if, then" procedure (portion)
correctly.

Range("CNT").Select
If isblank(CNT) Then '<-- This is the line I need help to

write correctly.
Selection.Offset (0, 5).Select

Thank you very much.
--
Rodney Getschman
Wisconsin VFW
.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
A logical test in the If function for blank, i.e., If blank? egii Excel Worksheet Functions 5 September 16th 09 11:46 AM
Conditional formatting to test blank text cell Andyjim Excel Worksheet Functions 4 January 10th 08 08:45 PM
test for not blank, use value in cell and set as variable Robert Excel Discussion (Misc queries) 0 March 24th 05 11:25 PM
Excel VBA Test For Blank Cell Esteban404 Excel Programming 0 July 28th 04 09:10 PM
Excel - To test for a Blank Sheet TKT-Tang Excel Programming 5 April 1st 04 04:46 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"