long

Hi all I want to check value in textbox1 in form(CDKT) with sheet("nb","ngb"). If found will copy row to sheet(ky1) and Ihave code below Code yelow at line: Set ans1 = TextBox1.Value And have VBA notice: "Object require" Please help me correct this code, thanks Sub...

Hi, I'm trying to use SQL within VBA to calculate several related things at once, but I'm doing something wrong I have 4 columns I'm interested in: ID, Description, Value and Date (see code for exact labels). I want to return a dataset that contains - unique ID - unique Description - sum of all...

Hi all I have code below work well but I want to change this line: <code style="box-sizing: border-box; font-family: inherit; font-size: 1em;">If Sh.Name <> "LocKH" And Sh.Name <> "Ma" Then to <code style="box-sizing: border-box; font-family: inherit; font-size: 1em;">If Sh.Name =...

Hi all I want to set lastrow always "> 4" and lastcolumn always ">6". I have code belovew and work well but I thinks have a better way to do. Could you have any suggession to do? My code is: Sub clear()Dim lrow As Long, lcol As Long Application.ScreenUpdating = False With Sheets("result")...

Hi. I am wanting to transfer data from one sheet to another within the same workbook. To put it in to context it is a spreadsheet for my work (school) for transferring data about pupil achievement in subjects. I currently have a table (on a spreadsheet called Pivot Table) in the format for...

https://chandoo.org/forum/threads/vb-code-to-insert-pdf-image.42675/ This is cross post, was not getting reply so posting here. I am using following code and it is importing jpeg image in cell range B14 : P28 (Merge cells) I need vb code which can insert pdf file as image in the same merge...

Can anyone help please? It looks right to me but when the macro finishes, it pastes my formula in AC1:AC3. There are breaks in the data however, by pressing Ctrl and End it takes me to cell AC520. Sub ConsolidateTimeSheets() Dim Wbk As Workbook Dim ws As Worksheet, wsData As Worksheet...

This is the data in my cell: <tbody> <tbody> <tbody> ANUZ2B2KI2XTG;ANUZ2B2KI2XTG;23.93+0=23.93;Me;26.12;Ig:r#5:A20AY8YZ1X41HY;A20AY8YZ1X41HY;23.96+0=23.96;Me;26.12;Ig:r#5:>A2FATTUNY7ADJL;A2FATTUNY7ADJL;23.99+0=23.99;Me;26.12;Ig:r#5: </tbody> </tbody>...

Hello everybody. I've just taken charge of the database you can see in this link. From this db, updated day by day (see column N), I have to produce some reports. https://imgur.com/wHb7VtH First of all I want to specify that my predecessor used to manage the reports with formulas, for this...

Hi, Since yesterday, I've noticed a number of macros running slower than before. I was using Excel 2013 and about a month ago upgraded to Office.365 I have a range A1:AK39 where A1 = Table name A2:A39 Months of the year, starting Mar 2019, ending Mar 2022 A2:AK2 Months of the year, starting...

Using countif doesn't work because formula in CF (= i don't wanna enter conditional formatting always) is too long with many other functions and there are 4 cells. Is there any other way to get results of formulas in CF outside CF? Thank you.

Hello: I am currently using Excel 2016 (64 Bit). I opened a workbook that is a few years old with a user form that used to have a context menu upon right clicking fields. I am no longer able to show the context menu with the below error: "Compile error: The code in this project must be...

I want to do SUMIFs for the following image but for more than one flavor criterion. The two flavors highlighted in yellow both have the same date and location, so I'd like to be able to get the total for them both without just simply typing another +SUMIFS formula for the second flavor. Mainly...

Hi, I have the following code. However, it would not run - I got the following error message: Compile Error: Invalid qualifier. Wonder if someone could point what the error is. Thank you! Sub update_MTD() Dim minus_day As Integer, sessionDate As String, current_Month As Integer...

Hey guys, i am making a small function to add up all the numbers between 2 numbers. My code: Sub Sums() Dim a As Long, b As Long, i As Long, n As Long, ta As Long, tb As Long, ak As Long, bk As Long a = 0 b = -2 ak = 1 bk = 1 If a - b = 0 Or a + b = 0 Then n = 0...

I am setting up a market timing study in excel and I'm having difficulty with the following: In column c I have many rows of numbers ranging from 0 to 5. These determine if I'm long (invested) in the security or neutral (cash). For example I start long and stay long many days until a cell in...

I'm trying to write a row to the end of an array the logic is essentially: i = loop through UBound of array 1 x = loop through UBound of array 2 if statement is true then add the entire row we are looping through from array 1 to the bottom of the array make changes to the new line and add 4...

For instance, I have a whole range of job roles and the count, and I want to group several functions together, such as: Group 1 Sales Marketing Business BD Business Development Group 2 Admin Administrative Accounts how do I filter and group them together easily as long as the job role...

Hello, I am making a user form and I'd like it to contain: a drop down list, and 4 labels + 4 text boxes. The idea is after a choice is made in drop down list, 4 label values are changed depending on array position, and 4 text boxes can update the values of the array. So i fill up my array...

Hi, I have the following code in a master spreadsheet that I am using to try and copy rows from one workbook to another workbook depending on the value in column R in the source workbook. Both workbooks are opening OK but nothing is getting copied across, any advice please?. Thx, John...