Topic profile page for Empty Cell.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Empty Cell.
Topic "Empty cell" was discussed 0 times on 0 sites in last 3 months
Started 2 days ago (2009-12-17 20:43:00)
by logan_fernandes
Hi, I'm new here, and need some help! I've been tasked with creating a spreadsheet at work to help give customers quotes on price plans (cell phone store!) Anyway, I'm stumbling through this and learning macros and what have you, with the little bit of VB knowledge I have, I'm stuck. I need to put a formula in my macro, that will go down my "A" ...
Started 4 days, 4 hours ago (2009-12-15 16:50:00)
by shadbolt
columns C through to O show the variance level of stock for different weeks. The cost of that item is in column V. So in column W i need a formula to to total the cost of that variance. However if we are down 2 items i.e the variance is -2 then the sum would be 2 x stock price but if the variance is +2 then no some should take place because I only want to account for the loss's/defiects....
Started 4 days, 22 hours ago (2009-12-14 22:49:00)
by jay83091
Hi All, I have a report with some of the cells blank because there is no value for it. I know how to fill those empty cells via displaying 'Undefined' values as 0. I know if I use it like this"FormatNumber([Measure];"(#,##0)") ", It will return positive numbers and negative numbers in brackets. Is there anyway to display 0 values for undefined or empty values using this method?...
Started 5 days, 11 hours ago (2009-12-14 09:08:00)
by Hitch75
Hi guys If A1 is an empty cell, and then I type in B1: =A1 , I get zero as a result, and I want the cell to be empty, as it is in A1. How can I do that? Thanks!
Started 5 days, 14 hours ago (2009-12-14 06:25:00)
by gootroots
If "C2" contains a value then find and insert that value in the last empty cell found in "B10:B" If there is no value in "C2" then the code shows a megbox "No record found in C2" the code does not execute. I want to include the necessary code to do this with Option Explicit declared in the module. Much ...
Started 1 week, 1 day ago (2009-12-11 07:00:00)
by colinod
I have the following to determine unused parts of a database and was wondering how to find it if the cell is just empty instead of having the word unused in it Expand | Select | Wrap | Line Numbers 0 then %>
Started 1 week, 2 days ago (2009-12-10 13:45:00)
by Tommanley
Can someone please give me a macro to highlight the cells Range("A4:S35") and find the first empty cell in that selection while keeping the Range highlighted.
Started 1 week, 4 days ago (2009-12-08 14:31:00)
by mmitchell76
Help with Average error #DIV/0! (dividing by an empty cell or 0 I am getting an #DIV/0! error (dividing by an empty cell or 0) I need the formula to work as I continue to add more data to the spreadsheet without redoing the formula. Here is the array formula {=AVERAGE(IF(--($I$7:I5000=A30)*--($R$7:R5000="Yes ")*--($L$7:L5000> =...
Started 1 week, 6 days ago (2009-12-06 16:07:00)
by Renonevada
Hi, This question is about creating an empty cell. Not a "" or 0, but completely empty. The thing is: I want to export a numbers file to .csv format in which the end of filled columns is also absolute end of row. Actually I need a dynamic table. I have a table in which 35-40 columns are automatically referenced from another table. Sometimes it goes to column 35, sometimes to 40. ...
Started 3 days, 9 hours ago (2009-12-16 11:33:00)
by gbrandreth
Re: Look up 1st empty cell Tell me what the values are where your getting a result of zero (confirming the cells they are in). Also put in the next blank column just the Counta bit, and tell me what nr it says it is. The formula works for me, so I suspect its down to blanks and the format of your s/sheet. Or your cell refs arent ...
Started 5 days, 7 hours ago (2009-12-14 13:46:00)
by Gotroots
Your code worked as hoped on its own. Hhowever I tried to run it inside other code but it stopped when it got to the line lngLastRow = not sure why it should do that "Ryan H" wrote: > Try this: > > Option Explicit > > Sub DataEntry() > > Dim lngLastRow As Long >...
Started 4 days, 21 hours ago (2009-12-14 23:37:00)
by Bobber
Hi Jay, I have had similar problems lately. Are you trying to simply format the data in the cells to show as 0 instead of blank?, or are you having an issue with the cells not showing on the report at all? Sounds like the former. If that is the case, make sure you have tried using a custom format, when you click on the cell and select "format number", and then select "custom", and you can ...
Started 5 days, 4 hours ago (2009-12-14 16:35:00)
by chuf
Thanks Andrew, I'll discuss with the team see what they'd prefer .. they may choose to remove the sorting.. as it may / should encourage them to go and look for the coloured cells... appreciate your help again Andrew. Thanks Chuf
