Remove "Ghost" Excel sheet object from VBA
Hello, I am unable to remove these "Ghost" excel objects left behind after deleting the sheet. I have tried multiple methods that I found on the internet to remove these objects, but nothing works. The sheets are not hidden. The sheets do not existing. That is the "hard coded" name created when the file is created from copying the "CAD" or "CAD_Template". The "remove" button is grayed out. I tried basically everything CoPilot could tell me to remove this. This is what it looks like below. When I run the program, the program creates "CAD4" as the next hard coded name.
Move based on value VBA
I have what I hope to be a fairly easy to solve problem in my VBA code. I have a tab where each row is a different project and each project has a handful of tasks. When the project is complete, the entire row moves to a completed projects tab. My problem is that some of the formulas that make up the tasks update when moved and reference the incorrect cell. I am trying to copy/paste values before the row moves from one tab to the other to no avail. The formula that I am really trying to paste the value of is in column D. Could anyone help me out? Thanks in advance! Dim xRg As Range Dim xCell As Range Dim A As Long Dim B As Long Dim C As Long A = Worksheets("Deliverables").UsedRange.Rows.Count B = Worksheets("Complete").UsedRange.Rows.Count If B = 1 Then If Application.WorksheetFunction.CountA(Worksheets("Complete").UsedRange) = 0 Then B = 0 End If Set xRg = Worksheets("Deliverables").Range("S1:S" & A) On Error Resume Next Application.ScreenUpdating = False For C = 1 To xRg.Count If CStr(xRg(C).Value) = "Complete" Then Sheets("Deliverables").Select xRg(C).EntireRow.Copy Destination:=Worksheets("Complete").Range("A" & B + 1) xRg(C).EntireRow.Delete If CStr(xRg(C).Value) = "Complete" Then C = C - 1 End If B = B + 1 End If Next Application.ScreenUpdating = True Sheets("Deliverables").Select ' End Sub
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,
VBA code just looping despite exit subs
It's been many, many years since I last dabbled with VBA in Excel. I am trying to put some text in I3 when I change a Data Validation List depending on its value. There are a number of values, but my code only looks for NONE, an empty cell (delete the contents), and the rest are weapons. The is a single If Then Elseif Else block. Regardless of what I do, I can't get it to exit to exit the sub and keeps looping. It fills I3 with "Selection is Selection is...until Excel crashes. Here's what Ive got: Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Address = "$B$3" And Target.Value = "NONE") Then Range("I3").Value = "Selection is " & Target.Value & ". You have no Melee weapon." Exit Sub ElseIf Target.Value = "" Then Exit Sub Else Range("I3").Value = "Selection is " & Target.Value & ". This is a Melee Weapon." Exit Sub End If Exit Sub End SubChart linking with Name Manager
so it's known chart behave different than other items, i linked it to a box that indirect the limit of which it should take values from a column, like i used this code to do it: =OFFSET('Study '!$F$25,1,0,'Study '!$BD$26), but this fails when i want it to take starting and ending limit with offset command, it just re input values, like if i want beginning to be 100 and ending to be 300 it reads first 100 and then reread them plus the extra 200 so i have 400 values. is it possible to make it so from column F it starts taking values from lets say box BC and the ending limit to be from BD? i tried looking it up and figuring it but you know how it goes with charts
Using mode with several criteria
Hello everyone! I'm currently treating some data before I send it to do some machine learning. I have the following data: id Ano mês data_inversa dia_semana horario uf br km municipio causa_acidente tipo_acidente classificacao_acidente fase_dia sentido_via condicao_metereologica tipo_pista tracado_via uso_solo ano pessoas mortos feridos_leves feridos_graves ilesos ignorados feridos veiculos And I created a new table to summarize this data for months instead of accidents, here are the columns: BR KM Ano Mês Clima (Moda) Tipo Pista Acidentes Veículos Ilesos Feridos Leves Feridos Graves Mortes Causa (Moda) Risco What I want to do is calculate the mode of condicao_metereologica for each combination of BR, KM, Ano and Mês. But I can't wrap my head around on how I could do this. Any help is appreciated! Let me know if I made anything not as clear as it is in my head xD
