lastrow and range

Hi! I have some logic which will copy and paste into a range using last row. that works fine: lastrow = ActiveSheet.Range("AY7:BB" & Rows.Count).Find("").Row - 1 Set CopyRng = Range("AY7:BB" & lastrow) CopyRng.Copy Range("AQ7:AT" & lastrow).PasteSpecial xlPasteValues I then want to re-copy...

Good morning all! I've been trying to used multiple posts for reference, but i'm stuck on the last piece of code to make this sheet work. When i create a new sheet, based on the submission of data through a userform, it should also copy the data to the new sheet created (to automatically start...

Hey guys, I need for the code to stop copying at the lat line with data, but cant figure out how to code it. Pretty sure i need to use lastRow, but Im not sure how to replace the range. Sub Main() 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm 'Don't forget to copy the...

Hi, I currently have some code that looks at data in row 2 of a worksheet. After pressing a button, the VBA pulls the information from the cells in that particular row, through to other cells in the workbook, it then automatically saves this info as a new document and then returns to the first...

Hi, if i use the current syntax with this macro i get an annoying "clipboard has a lot of info on it" popup. To avoid it i would like to use the non paste method, but i cant figure out the appropriate syntax for the situation. Thanks for any help. This is the code section in question...

Thanks in advance for anyone who is assisting. I will test any recommendations and will let you know the outcome. Item: I've found the last row in my data ("LastRow"), and now I'm trying to set a formula in cells A5 to "LastRow" to a formula, but I'm getting errors. The First issue seems to...