deleting

Hi, I am wanting some code which will loop through a column of text as such: <tbody> 40 8 Lynton 8 22 Field 2 19B </tbody> deleting the cells which do not contain just numbers! Any help would be appreciated! Thanks

Hi, I'm hoping to create a VBA macro in excel to automate a task of deleting rows if they contain a zero in columns AB and AC. However I do not want it to delete blanks. Can anyone help? Thanks!

I need to create a macro for deleting entries falling on Weekends. I have a conditional formatting formula that colors the cells falling on Weekends "=WEEKDAY(L2:AP2,2)>5. So, I would need the macro to be able to delete entries from coloumn 3 to 799 if L2:AP2 is a Weekend day. Thank you in...

Hello, I have written the following code to delete all rows where the cell in column J is Blank, but currently it is deleting all rows Dim uLastRow As Long Dim u As Long uLastRow = Cells(Rows.Count, "d").End(xlUp).Row For u = uLastRow To 1 Step -1 If Cells(u, "j").Value = ""...

Hi I have a worksheet which has formulae which reference multiple other worksheets, e.g. <colgroup><col><col><col></colgroup><tbody> A B 1 Sheet 1'!W367+'Sheet 2'!W367+'Sheet 3'!W367 Sheet 1'!Z367+'Sheet 2'!Z367+'Sheet 3'!Z367 2 Sheet 1'!W370+'Sheet 2'!W370+'Sheet 3'!W370 Sheet...

My code consist of a large formula. And I would like to keep on adding to the formula in the VBA. But it looks like I have reached my maximum in that formula that it spills into the second line on my VBA. When that happens my formula breaks. I was wondering if someone had a solution to this...

I'm having trouble with the below not deleting the entire row. For Each cel In Range("L1", Range("L" & Rows.Count).End(xlUp)) If Left(cel.Value, 1) <> 8 Then cel.EntireRow.Delete End If Next

I download the same excel report daily. Is there a way to open this report with the same headings/columns that I want to see. I am deleting and hiding half of the columns for my report

Hi, I am totally new with VBA and was trying to make a macro deleting rows based on certain criteria. With one criteria it worked just fine, but I am struggling to add a second criteria. In short, below the code that I have so far. I need it to delete all rows that do not contain "Sales" in...

I have a spreadsheet with 50 worksheets. The information from 49 of those feeds into the 50th worksheet. I am wary that someone could delete one of the 49 worksheets and the calculations can go awry. How do i stop someone from deleting the worksheet HOWEVER allowing them to still rename the...

Hello, I have a quite big file of 30,000+ rows,. It's full of sumproduct formulas, It basically checks prices in sheet1 and adds them up in sheet2 to check how much employee earned and based on that what is going to be his salary(10% above minimum to earn + add on). My only problem with...

hello, I need to move a cell (A2) and it's adjacent cell(B2) up and delete the two cells above it (A1) and (B1) Thanks

Hello. I am using simple macro to copy some Values onto another sheets of another workbooks. But before paste of Values i need to delete remaining Values in COPYpath workbook. And here came the problem, because i need to vba not to clear values including format of page. In workbook, where i...

I've got a file that's sluggish/laggy and trying to pinpoint the cause, and noticed something very odd. Column CM in my sheet is completely empty (e.g. Ctrl-up takes me to CM1, and Ctrl-down takes me to the bottom cell in the column, so no data whatsoever in it). But when I delete the column and...

Hi All, I want to make a template where it should be possible to add data but it should be prohibited to delete data (not by deleting lines, but also not by deleting data from cells.) I tried to fix it with a VBA code i found online but that doesn't work. Who has the solution? Thanks in...

Hi guys I am trying to figure out why I am getting a type mismatch when deleting rows past a certain number. Well I am not sure if this is because its a large number of rows but here is the code I use. With Worksheets("PWPCP") Rows("6:" & .UsedRange.Count).Delete End With I made this to...

hi in excel 2013 I have a line chart on which I would like to just show the final (right hand side) value against the line. Is there a simple way of doing this other than clicking and deleting each value except the last. any help appreciated

So I am needing to clean up my data some and that entails deleting rows that have D, F, I, O, Q, or U in them. Theres 4637 rows so it would be rather difficult to do this by hand. Is there some way to take the first 3 columns (A B and C) and if they contain D, F, I, O, Q, or U in any of those...

Good afternoon - I have a tab (Tab 1) that I use to track headings for annual financial statements and another tab(Tab 2) that tracks headings for interim financial statements. I want to be able to have Tab 2 always match what has been changed in Tab 2. So for example of I want what has been...

Hello, I've been fiddling around with multiple codes and macros but none that are working. I have an excel macro that pulls in data, then we run another macro on that excel sheet. When it pulls in data, for whatever reason it is pulling in bad cusips. So what I need to do is search all sheets...