Hi I use a code to copy paste from a one drive excel sheet to another This is my code to open the file: Public openwb As Workbook Sub testOpenWBOneDrive() Dim wbFullName, objLogExcel As Object Set objLogExcel = CreateObject("Excel.Application") objLogExcel.Visible = True wbFullName = "https://mysmartplace-my.sharepoint.com/personal/Misc/data.xlsx" Set openwb = objLogExcel.Workbooks.Open(wbFullName) End Sub And my code to… Read More Excel to close trailing window

Here is the code: Private Sub Query1_Change(ByVal Target As Range) Dim myRange As Range Dim myCell As Range Dim wsComments As Worksheet Dim wsQuery1 As Worksheet Dim lastRow As Long Dim i As Long Dim foundMatch As Boolean Set wsComments = ThisWorkbook.Sheets("Comments") Set wsQuery1 = ThisWorkbook.Sheets("Query1") If Target.Row < 2 Or (Target.Column <> 31 Or… Read More Why won't this VBA code write or update records to a new tab?

I have written this piece of code: thisworkbook.Sheets("test_destination").Range("J2:K" & lastrow_orgid).Value = Application.WorksheetFunction.Unique(diesesworkbook.Sheets("test_source").Range("J2:K" & lastrow_orgid).Value) It does what it is supposed to do but it creates these #NV values. Maybe someone could tell me if there is another way to write this to avoid these #NV values. >Solution : Couple of things. Work with objects. This… Read More avoid #NV values with excel vba

i have a code below it was working fine then suddenly the line arr = split(cell.Value, ",") has an error wrong number of arguments or invalid property assignment i just inserted the lastRow variable, even if i changed the range something fixed like A1:A10 it is still the same error Sub split() Dim rng As… Read More split then add to array working before then suddenly not working

I had a code that would place 1 or 2 values in a cell at random (The values were either "SF" or "BM") and I used to do it this way Worksheets("Sheet1").Range("A1").Value = IIf(Rnd() > 0.5, "BM", "JC") The problem is that I want to add a new third value "KS" and doing the following… Read More Place one of three values in a cell at radom

I’m new to Excel VBA and I’m having trouble understanding how to create a simple line chart, with multiple lines. I have done multiple tutorials and everytime I want to customize my code, I look online and find a totally different syntax for creating a chart. What is the best method to configure a chart.… Read More How to configure a Chart

I need to automate the process in which the range of data is selected. Right now the user gets prompted to input the data range through an input box and it creates an XML file with that data, but I need it so that the script gets the data range from the Excel sheet where… Read More How to automatically get a specified range of data from Excel to XML in VBA

Let’s say I have a cell "A2" and I want to locate on this cell either the initials BA or CF (I want to do this randomly) How would I able to do that? So far I have Worksheets("Sheet1").range("A2").value = "BA" but I don’t know what I can do so that from now on it… Read More Add one of 2 values to a cell randomly

I want to duplicate each row in a worksheet 57 times per row, across 39 columns (after the result, meaning there would be 58 duplicates of each record). So for example, I have included a snippet below of what some of my records look like now (take in mind, there are 39 columns, snippet cant… Read More How to duplicate rows

i would like to paste a value in a given cell in Column A (empty column), i would like to autofill copy this down up until the next empty row or data in column B. I can do this by specifying a range to copy down to but i would like for this to be… Read More Autofill Copy down up until next empty row- Excel VBA Macro