empty

Hi all- I’m really struggling with the last step of my variance reporting for my company. I have a workbook with 30 or so sheets. Each section of business has 3 sheets. One of these sheets has been formatted to highlight certain variances that need explanation. I want to create a summary sheet...

I found this code to copy/paste a range from sheet 1 to sheet 2 onto the next empty row. It was working great until I switched to office 365. Now it won't paste onto the next empty row. Can anyone tell me what's wrong with it? Thanks! Sub SUBMIT2() Dim copySheet As Worksheet Dim...

Hi, Can anyone help with below? My code is running for around 5 minutes or more with data of only 10 records in the worksheet. Dim nameCol As Range Dim aCell As Range Dim Cell As Range Dim Cel As Range, N& N = 0 Set nameCol = .Range("A1:AU1").Find("apple") Set...

Hey, So I am working on a project and the powers that be would like to be able to type one row of data into an excel sheet, we'll call it Main, and have any new lines appended to other sheets based on whether the field is empty, department specific. Originally I was grouping all the sheets...

Is the null (0 length) string ("") the same as Empty or not? The Immediate window seems confused or ambivalent: ?"" = empty True ?isempty("") False xblank = "" ?xblank = empty True ?isempty(xblank) False It appears that Null is different than anything else: ?null=empty Null ?null=""...

Hi all Hi have code belove will adding value (like =sum) from multiple sheet to master But now I all value will be combine (not add), so please help me change code to do that thanks./. For Each k In .SelectedItems<code style="box-sizing: border-box; font-family: inherit; font-size: 1em;">...

Hi all, Hopefully an easy one. =SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B)) Essentially want to multiply and sum Column E and B together if C = "Equity" Columns E and B contain empty cells, which appears to be the root of the problem. Any ideas? Thanks, John

Good day, My question is quite simple : I am trying to return the last empty row from a table (Line number where the data will be inserted) into a Text Label that will show on my UserForm. I've looked around and I couldn't stubble upon anything relevant. Thanks,

<tbody> A B C 1 2 =2^a1/(2^a1+2^a2+2^a3) 2 2 3 </tbody> So I have this formula which also takes into consideration empty cells (a3) for future entries. Formula is very simple but works only if I include non-empty cells to that equation. As you can see above a3 is...

Hi Can someone please advise what the quickest way of checking if a range of cells eg A1:Y1 is empty, using VBA, please? I found this code online, but I'm not sure how to modify it....? <tbody style="box-sizing: border-box; border: 0px !important; margin: 0px !important; padding: 0px...

Hi there, I have some code that is speeding up some checks that I do every week over 1000 rows etc. I am just after a little help in speeding up my checks as this is tedious work. What I am after is for a macro to check if the the previous column (i.e. Column R) has the same value in it and and...

Hi, I am writing a macro that will delete all comments (on the worksheet) that are empty. By "Empty" , I mean either of 2 things: (1) The comment box is absolutely empty: nothing in it. The user can create such a comment by selecting a cell and clicking a macro button. The macro...

Hello Will this command delete empty cells in that range? Range("A1:A10").SpecialCells(xlCellTypeBlanks).Rows.Delete Shift:=xlShiftUp

hi guys, new to the forum.... im trying to code up in VBA but stuck at the moment hoping to find answers... basically i have this worksheet tab call "Fruits", with a column header starting at cell A4 call "Fruit Types", and subsequently A5, A6 onwards have different names of fruits. Basically I...

hi guys a have a range of cell example A1 B1 C1 D1 E1 if i click the button a message will tell me that i have a blank cell on range, and if theres no empty cell it will save my worksheet, thanks

Hi Could anyone help me with the following? I would like to create a VBA that copies the first found value in Column A to the empty cells below - until the next filled cell in Column A occures. Then this value is copied to the empty cells below etc. - until there are no more entries in column B...

Hi. I have a table with a column A containing filled cells and empty cells. I would like to create a VBA that copies the filled cells to the empty cells below, and when a new cell value occures, this will be copied to the next cells below etc. until there are no more values in column B. Would...

Morning, When i click the drop down arrow on a Combobox i see the only one option to select of which in this case is N/A But below that option there is a empty space/gap. Please advise how this can be remove. Here is some info to assist you. Code for the Combobox. 'INVOICE NUMBERDim lastroww...

Hi, I have a line of code as follows: Kill tempPath & "*.*" which works exactly as I want. I deletes all files in a temporary folder before running the rest of the macro. The problem I have is when there are no files in the directory (i.e. it's an empty directory) then I get a "Run-time...

Hi. This is quite simple but i just don't know how to get around it. The formula C+(A*B)-D C is essential in computation but often empty. this give me a value error if C is empty. What should be the right formula, not to get value error? Thanks