1. G

    If Not IsEmpty Error

    Hello, Some context for this issue. I am trying to move over this whole VBA code to my personal book that is stored in XLSTART and run the macros off that moving forward instead of having them in the reports themself. The code below works fine in the document on its own but doesn't work when I...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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 = ""...
  9. 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 =...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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")...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back