lngrow

Hi I have the below code which copies a range data from a workbook and it works well. I just want to copy formatting such as borders and font colour etc. I have tried using .PasteSpecial xlPasteValuesAndNumberFormats as per below but it doesn't seem to work. = ws.Range("A1:A13").PasteSpecial...

Dear friends, I would like to import the following: Table 0 from: https://www.global-rates.com/interest-rates/libor/american-dollar/american-dollar.aspx Another table named: additional information per maturity from: https://www.global-rates.com/interest-rates/libor/american-dollar/2019.aspx...

Hello, I'm trying to create a loop that checks the names in column A with the names in column D and E. If The names in A are different from either D or E and the cells aren't empty I want to duplicate the line. I got the line duplicating, but it's not ignoring empty cells and duplicating...

I am trying to compare the values in two columns for consecutive rows. Specifically, I would like to check the value under Column B and Column C of each row with the one directly above it. And if it matches, perform some XYZ action. I have the code below which I tried to use but it keeps...

I am trying to send a progress message from a custom VBA function - I get no errors, just never see the messages on the status bar. I have stepped through the function and confirmed the display command is executing. I can run a SUB from this same workbook/module and see the status bar updated...

I have a parts list and i need a method to hide Column C and filter Column D5 and below (my quantities are entered in Column D) upon clicking cell B3. Then upon clinking again cell B3, re-show (un-filter) all columns and rows. I have something already similar in for another worksheet.... but i...

Option Explicit Sub TeamTotal() Dim lngRow As Long With Sheet1 'find "Team Total" position lngRow = Application.WorksheetFunction.Match("Team Total", .Range("A:A"), 0) 'apply the sum formula .Range("B" & lngRow).Formula = "=SUM(B1:B" &...

HI all, I am using one macro file with below code . it`s perfectly file but now I need add one condition in same macro file . New condition is : if in my Raw data worksheet column E having some specific model like C400,n9000,q10000 . than calculation method id different , example file...