del

Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?

Hi, Please help me regarding these below: 1st. How to get all capital letters in a cell. I want to get only the "DEL REY(AM)" Sample: Alejandro Jay DEL REY(AM) 2nd. How to get the remaining full first name. I want to get only the "Alejandro Jay" Thank you.

I want to use the cmd /c del command to delete a file, instead of Kill. This works: Dim Loc As String Loc = "C:\MyFolder\abcdef.xlsm" Dim cmd As String cmd = "cmd /c del " & Loc Shell cmd but if the filename contains a space like this, it fails...

I am stepping through and deleting marked rows in my sheet. If I miss the header row the macro runs but fails to delete one highlighted row. If I include my header, I get a run time error. I have fixed it my including i = 1 before the loop ...but I cannot get my head around my it fails...

I have some drop-down menus, but when the a presses DEL and clears the field - it is messing up my formulas. How can I pre-set the drop-down menu to show [%] whenever the DEL button is pressed? Thanks Ryan

I have a macro that works, but is actually slower than when I did it by hand. There are about 10000 rows that have to be looped thru and the purpose is to delete rows that meet certain conditions. Basically what it does is put the word "DEL" or "KEEP" at the end of each row and then loops...

<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> Need your help guys, I have this example regarding my concern of giving me the figure from cell C...

So, I posted a few days ago, but had an invalid explanation of what I was looking for. Apologies to the community. Here is a what I was looking for. I have these group of cells: (See Below). My problem is, if for example, I input, on another cell, pickup weight forecasted at 52,000, and...

OK, maybe I'm just not awake enough today, but I also should know more VBA than I do I'm using VBA to delete entire rows if a specific column/cell is blank- that part is fine. I'm using Dim rng As Range, cell As Range, del As Range..... But after that I'd like to delete entire rows if a...

Hi, Thank you for this site! I've learned so much just reviewing the posts and challenging myself to write better and more increasingly more complex code. Here's what I have: -All Cells are Unlocked and Sheet is Protected with no password -Cells I6:L14 MERGED across each row (I6:L6, I7:L7...

Amigos, buenas tardes. NO hablo ni escribo Ingles. Tengo un dilema del cual no se darle solución, siguiente: Un formulario que se ejecuta desde hoja INICIO que me sirve para dar alta y baja de artículos según necesite en la hoja que seleccione en un combo. Ya le coloque código, (aunque fue...

Hello, I am trying to consolidate 4 worksheets into 1. The problem I am running into is that I am trying to add values to cells based on what is ported over from a specific sheet, when I try it the values I am adding just overwrite each other. Sub FN_Upload() Dim wksDst As Worksheet Dim...