Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
I am using the following the line of code in a macro
Do Until Activecell = "" I then use the Offset command to move down cells in the spreadsheet. Some of these cells have data hard coded into them and others have a link to another worksheet within the spreadsheet. If the linked cell has no value, ie completely blank, then the cells I am checking have a 'blank' value. when the above code gets the the linked cell it assigns a value of '0' (zero) and doesn't recognise is as "". I can't use Do Until Activecell = 0 as some of the hard coded cell have a value of '00000' which again is recognised as '0' (zero). I have tried various combinations to try and resolve but am not having any joy, can anyone help with what should be a very simple problem. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
Would it work if you used :-
Do Until (Activecell = "") OR (Activecell.Value = 0) Sean "Just press the off switch, and go to sleep!" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
No, as some of the cell have '00000' hard coded into them
which is recognised as '0' -----Original Message----- Would it work if you used :- Do Until (Activecell = "") OR (Activecell.Value = 0) Sean "Just press the off switch, and go to sleep!" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
Use something like this choosing a suitable column :-
Code ------------------- lastrow = ActiveSheet.Range("A65536").End(xlUp).Row For rw = 1 To lastrow '-etc Next ------------------- -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
If the cells actually appear blank then you can do
do Until ActiveCell.Text = "" However, a cell linked to a blank cell usually displays zero. you might use do until ActiveCell.Hasformula and ActiveCell.Value = 0 If you have zero values suppressed with Tools=Options=View tab, then the first method will work with linked cells (even though they have a value of zero). -- Regards, Tom Ogilvy "MIKEYMAY" wrote in message ... No, as some of the cell have '00000' hard coded into them which is recognised as '0' -----Original Message----- Would it work if you used :- Do Until (Activecell = "") OR (Activecell.Value = 0) Sean "Just press the off switch, and go to sleep!" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognising cell values
See one more suggestion at your other thread.
Mikeymay wrote: I am using the following the line of code in a macro Do Until Activecell = "" I then use the Offset command to move down cells in the spreadsheet. Some of these cells have data hard coded into them and others have a link to another worksheet within the spreadsheet. If the linked cell has no value, ie completely blank, then the cells I am checking have a 'blank' value. when the above code gets the the linked cell it assigns a value of '0' (zero) and doesn't recognise is as "". I can't use Do Until Activecell = 0 as some of the hard coded cell have a value of '00000' which again is recognised as '0' (zero). I have tried various combinations to try and resolve but am not having any joy, can anyone help with what should be a very simple problem. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recognising dates pre-1900 | Excel Discussion (Misc queries) | |||
Excel still not recognising equal values | Excel Worksheet Functions | |||
SUMPRODUCT not recognising dates | Excel Worksheet Functions | |||
VLookup not recognising numbers | Excel Worksheet Functions | |||
Recognising '0.00' | Excel Programming |