isempty

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...

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...

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")...

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...

I don't know why this is so hard. The goal: Go through Column R, rows 2 thru 46. If the cell is empty, delete the whole row, then check the next row in Column R The number of rows is fixed. It'll always be 2 thru 46. (My research shows lots of code for variable length ranges) Among other...

I'm trying to go down every column and delete blanks by pasting up but I think I have an error in my coding. I have a date associated with number so I actually have to shift up two columns for every cell but I think the problem lies with the IsEmpty Cell Function. If anyone has another way to...

Hello: I've got a recursive loop stepping through rows to copy cells from Sheet A to Sheet B if they are present in Sheet A. I am currently struggling with a method of determining if a certain range of cells is empty. The range is from Cells(i, 60) to Cells(i, 101) or range("BH" & i ":CW" & i)...

Hi, In one of the modules for a workbook of mine, I have The following type defined: Public Type Mode_S_Message_Record Mode_S_ID As String DF As String Msg_Type As String NACv As String ADSB_ID As String OTGI As String NACp As String SIL As String Lat As...

I'm having some trouble getting a private sub to initiate and I'm sure it's because I don't have a target specified. The first part of code puts a checkmark into a cell if it is clicked and that initiates another code called "BUILDER": Private sub worksheet_selectionchange(ByVal target As...

As a follow-up to a previous post... I'm trying to get a macro to run on a change in a cell. Here's what I have so far: Private Sub TestClick() If Not IsEmpty(Target) Then Sheets("Sheet 3").Columns("A:A").Hidden = True Else End If End Sub So if the target cell is not empty then hide...

Hi everybody, I wonder if someone could help. I'm writing some code to help calculate a variance between actual and target figures. Unfortunately, the spreadsheet sometimes contains . which need to be ignored, if not they skew the calculation. I've used the following code: Sub...