last_row

Hi- I haven't had much need to write VBA code in a few years, so I'm pretty sure this is straightforward. I'm trying to copy paste a range of variable size and am getting a '1004' error when selecting to the right. Basically, I have input data, and then output data which applies formulas to...

Hi, I have a large workbook comprised of sheets dedicated to a specific product. Each product sheet has a list of dates. I’m trying to create a macro that would tally the number of date entries corresponding to the month and year of todays date. So if today is “13 June 2019” the macro should...

I'm trying to be more concise with my code so I've attempted to set variables instead of activating sheets as I go. However, it appears as though nothing is happening after I hit execute. The point of this sub is to copy all rows with a blank value in column "O" from two worksheets and paste...

Hey everyone, I've created and named a sheet based on a list in another sheet. Which works great: Dim WB As Workbook Set WB = Workbooks("Workbook") Dim List As Worksheet Set List = WB.Sheets("Sheet1") Dim r As Integer Dim Last_Row As Integer Last_Row =...

Hi Experts - i have a problem with my code. I have a conditional formatting rules i set that highlights the cell if it has a value of FALSE or DUPLICATE. It works right after i set the rules however the rules get deleted after running below code. Do the rules get deleted by any of the codes...

This code want copy. Error: object required. Sub last_row() dim last_row as integer dim rangecopy as range last_row = Range("B" & Rows.count).End(xlup).row set rangecopy = range("a1:" & last_row).copy debug.print rangecopy.address end sub

Statement invalid outside of type block: Sub last_row dim last_row as integer rangecopy as range last_row = Range("B" & rows.count).end(xlup).row rangecopy = range("A1:I" & last_row).select debut.print rangecopy end sub

Trying to select a range but get a run time error 1004: Sub last_row() dim last_row as integer last_row = range("B", & rows.count).end(xlup).row range("A1": & "I"&"last_row").select end sub

Have written a macro to identify the last used row in a column: sub_find_last_row() dim last_row as integer lastrow = range("B2"), range("B" & rows.count).end(xlup).row end sub I want to test if a row number was assigned to the variable so I open immediate window: ? Last_row But no number...

Using Excel 2010. I want Excel to alert me if a cell value is NOT equal Base or 2*Base, but when a call is NOT Base, it could be 2*Base, or vice versa; hence Excel always tell me it is wrong. How should I modify my below code? Thank you Sub SubTotal_test() Dim k, i, j, minim, countleft...

Hi all, Let me try explain what I'm trying to achieve.. A worksheet is activated using the ref from cell A1 of the 'Front' sheet, so if A1=3 then sheet called '3' is activated. Then from row 39 of that particular sheet (Column C) copy any text that is Underlined then paste this into the next...