lastrow

Hi, i always encounter error whenver i delete last entry on the excel using the selected indx on listbox i have a listbox SBL_list.List with items coming form Worksheet SBL_T2K ( 9 columns) i need to delete the selected entire row on the listbox from the excel sheet. no error encountered when...

Hi there. Looking for help with vb script that inserts data to 3 different worksheets using an userform with a commandbutton_click. Found a script (non AI) LastRow that works for the first worksheet (Guests), but for the other sheets Diver Details and Book and Travel it will put the entered data...

Hello all, I have a piece of VBA that identifies the last row in a column, so that I can assign values: Lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("A" & Lastrow).Offset(1, 1).Select BankNo = ActiveCell My issue, is I recently formatted the data on the worksheet as...

I've found code that will copy select data from (Sheet1) to another (Sheet2) ; using only values found in columns "B:E" and "I:K". Columns "I:K" will always have data on each row pasted on to Sheet 2. Columns "B:E" may not have data on each row. Code from Sheet1...

Hello and thanks for reading this! (I apologize for length, but want to be thorough so you don't have to try and read my mind. Good question = good answer right?) The code below works the first time through, but the code will be ran multiple times. It's a two step copy and paste based on...

Hi all, I'm getting a syntax error when trying to run this. What I'm doing is: I have workbook open, then when I run vba it asks me to open another workbook, from which it copies from B4 until E last row in worksheet called balances. Then it pastes data in current workbook from A last row. A...

Hi All, This is the code I am trying to execute. I am getting the result correctly. But my issue is instead of lastrow sheet in the same workbook macro creates a new workbook with a new sheet named as the last row and giving output there.. Why it's not giving the result in the same worksheet...

Hi All, I am trying to find the last row using VBA in the table. I found the last row but my challenge is how to store that value and compare it with new last row. My aim is to if any changes in the last row, it will trigger a macro. Thanks in advance. Regards, Vigash

Hello, I've created a workbook with 4 worksheets that have been copied from other workbooks. In this workbook I'm trying to copy and paste all data from a column in sheet1 to sheet2. I'm using the following vba code: Dim lastRow As Long lastRow = Cells(Rows.Count, 1).End(xlUp).Row...

I created this macro to count the number of rows starting from column B. Then I created a cycle to fill columns 3,4,5 and 6 with excel formulas. my problem is that the references should be relative and not absolute (b5,b6,b7 and c5, c6,c7...until the last line). I can't finish the macro. Can you...

Hello, I'm creating an excel template with a formatting macro. The template will have data of varying length added to it (could be 10 rows, could be 1000). I created a macro using Record Macro, then added a section to add a border after each unique value in the last column. It's working great...

Good morning, I have the following macro. I simply want it to look at A1 on the current worksheet, if that cell has data then move down to A2. Then the next time I important data it will look at A2 and paste in A3 etc. Not quite sure how to do this myself, any help is appreciated! Private...

Hello, I have an excel database with about 50 unique sheets. The formatting of these sheets is the same in all cases but each worksheet is for a different supplier, some worksheets contain 10 rows, some 450+ I made an userform, to make it easier to add, edit, etc. the products listed on these...

Hi guys! Long time reader, first time poster. Getting very frustrated with my VBA so any help is appreciated. In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H. My VBA code...

Hi guys, I am trying to write a code within a userform which can be used to enter data on 3 columns. The columns are F, G, H and the row start from row 4. But when I try to run the code I get an object error on ActiveSheet.Cells(lastrow + 1, 6).Value = TextBox1.Value. I'm new to VBA so the...

Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?

Hi guys, I have the working code below, however when I try to added to run in a change event the Range with lastrow stops working, wondering if any of you can advice on what can I do? Sub field_change() Dim LastRow As Integer With ActiveSheet LastRow =...

Hi All, Could you please help me find a way to fill in the blank cells that should start from the LastRow + 1 in Col B and go until LastRow in Col C? At the moment the data is just being pasted over the lastrow in Col B. Loop in question is the last one, rest is just used to show more or less...

Hello, I am trying to finding the last row with a value. -I know how to do this typically by using "xlUp" but for some reason it is stopping at a cell that does not contain a value but just a change in color. -I am now trying to find a different way to go about this. Instead, I want to...

I want to highlight cell b37 and until the last row (which might change) in order to format that range of data this is what i have so far, whereby i have declared at the very start of the code the following: Dim Lastrow as Long originally i had it as range("B37:B150").Select, but i had to...