isempty

  1. E

    VBA loop code Error help!

    I am running the below code and getting an error at the end when the do untilempty is not working and the code runs until the third line and there are no more rows in the spreadsheet since column G had no data in any cells. Can someone please help me figure out the error in my coding. Thank you...
  2. C

    VBA IsEmpty Function not working properly

    Hi, I have a database of our clients, and the columns are arranged in the following way <tbody> A B C D E F G H I J K ID NAME PHONE ADDRESS CITY STATE ZIP WEBSITE E-MAIL/CONTACT FORMS INDUSTRY STATUS </tbody> I have the following macro, which works great. It basically loops through the...
  3. Mackeral

    "IsEmpty" Function

    I have found 2 different versions of documentation for the VBA function "IsEmpty": One on TechNet says the function is used to test "if the value is a blank cell or uninitialized variable, the function will return TRUE. Otherwise, the function will return FALSE". The other on Microsoft says...
  4. L

    Infinite Loop Correction

    Hello, I have been trying a lot of different methods to achieve the desired result however close but no cigar. The code below does what I need but I have an infinite loop which results in a run-time error. Sub DeleteBlankTesting() ' This code deletes empty rows if GRNSTATE is empty. Error to end...
  5. K

    Cell validation (IsEmpty) and returning MsgBox

    Hey guys and gals, I have the following code which checks multiple ranges for blank values and returns a MsgBox for each cell when IsEmpty = TRUE Sub Check_Event_Form() Dim cell As Range For Each cell In Range("D10,D14,D18,D28,D41,D44,D46,D48,D53,D56,D73,AH73") If...
  6. S

    ISEMPTY does not want to work properly. Someone help me out of this.

    I am looking to fill in blanks in the selected range with the word "Research" IF the cell is blank then cell = "Research" Simple enough, yet my mind is drawing a blank. The code below puts the word "Research" in the Header (U1), instead of in the blank cell. Something is missing, what...
  7. 3

    Selecting and Copying Cells in Range if not blank AND are not hidden

    Hey Folks! I'm trying to select and then copy cells within a range if a there is data in a specific column. If there is, I need it to copy all those cells in that row range even if it has some blanks in other cells in that range. I was trying this: Sub CopyPt6() If ActiveCell = ""...
  8. R

    VBA - Using IsEmpty to check a range of cells

    Sub ShowStockWithRisingPotential() Dim sheet As Worksheet Dim CurrentRowNumber As String Dim RisingValue As Double, RisingThershold As Double, RisingTrend As Double, Result As Variant, i As Integer, j As Integer, Stock As Long CurrentRowNumber =...
  9. J

    "Empty "cell is not empty?

    Hi All. I have a cell where I have used both ws functions and VBA functions to test content. The cell appears to have no content, but still it is not empty. VBA: isemtpty(cell) returns false WS: isblank(cell) = FALSE code(cell) = #VALUE! istext(cell) = TRUE I'm in doubt about how to...
  10. G

    Excel Macro - Using IsNumeric and Cell IsEmpty as a condition

    If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...
  11. G

    Excel Macro - How do change my code If Cell is Empty The Code should End

    Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...
  12. R

    Do Until LOOP Help

    Geniuses, I am having a bit of trouble getting a piece of code to loop. I have a button that once clicked will do exactly this: If Duplicate_Find Is Nothing Then ActiveCell.Copy ActiveCell.Offset(0, 2).Select ActiveCell.PasteSpecial...
  13. M

    Help with modifying macro to check if cell in range is empty

    hi all, i would appriciate some help :) i have two sheets named Unos_treninga and Test. I need to copy range I16:AA40 from Unos_treninga sheet to sheet Test to first empty row. There is condition - copy cells if cell in column I is not empty. data is entered in every row in range, there is no...
  14. R

    IF Not ISEmpty Autofill problem

    I have a macro that will autofill column C with the contents of "C1" to the last used row from column A. This code works great unless row 1 is the only row. That is why I used "If Not IsEmpty("A2") Then" because I wanted it to recognize that if "A2" is empty then do not autofill. When i use...
  15. S

    How to Calculate "Average %" dependent on Cell Value

    Hello Everybody, I'll try my best to explain this complex situation. There is data in column A and Column D. Data in column A is account no and data in Column D is some % value. Each account can have multiple % (please refer table below for example) Now I am trying to write a code to see if the...
  16. N

    VBA Problem: Changing top border thickness if...

    Hello, I am pretty new to VBA and am trying to write something that will make the top border between B and G thin where the C column is not empty, and make the top border thick where the B column is not empty. If both C and B are not empty it should make the border thick. Here is what I did...
  17. A

    VBA XL 2010. Loop, define set of cells in a named column

    Hello everyone, I am a begginer in VBA and had no real training so I am learning on my own by reading books and exploring forums. I went through many posts in several forum and Microsoft websites in order to write the code I need but unsuccessfully. What I am trying to do: If the cells in...
  18. R

    Empty Cell with variable range

    Hey! In my macro I want to check if a cell is empty or not before writing it over, but with my code it always thinks the cell is empty, what am I doing wrong? Sub Macro 1 Dim r As Integer r = Application.Match(Sheets("Sheet1").Range("A1"), Sheets("Sheet2").Range("A1:ZZ1"), 0) If...
  19. R

    Searching a range for IsEmpty()

    Hi, I'm trying to search a range to see if any cell contains a wild card End* I'm not sure how to make this code work. Dim cell As Range Set WS3 = ThisWorkbook.Sheets("Sheet3") Set WS5 = ThisWorkbook.Sheets("Sheet5") Set WSH = ThisWorkbook.Sheets("Sheet6")...
  20. A

    Do While Sytax

    Hi all , I wrote code that works just fine, however, I realized there were parts of the data I was using that had 0's in it for holiday. Bottom line, this is code that calculated the weighted average of prices for 12 months (12 rows across) and Drows across. I'm trying to use the "do while is...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top