What if I need o do this on a filtered list? I need to move to the cel on the first row of a filtered list anc copy it. I tried doing it as explained in this video but I don't go to the first cell on the filtered list but to the first cell on the sheet (just below the filter row).
Hi, there are many ways to do that, one of which would be to use a loop. Dim rng as range Dim cell as range Set rng = Range(put your range here) For each cell in rng cell.value = ... Next cell
Not without looking at a sample. Head to the Excel forum and upload a sample file along with the code that you are trying to get working and it will be easy to troubleshoot) www.teachexcel.com/talk/microsoft-office?src=yt_comment
I just tried to copy data (databodyrange) from a "formatted Table" in sheet 1 and paste it into the next empty row of another "formatted Table" in sheet 2 using Range("A1").End(xlDown).Select, It worked fine(It went right below the header), but when I try a second time with the same data set from sheet 1 using the same code I lost the last row of the 1st attempt(overwriting the last row). Any suggestions?
On a basic workbook, I tried to execute this macro: "Range (“S9”).End(xlDown).Offset(1).Select", but it came back with this error: "APPLICATION ERROR '1004' Application - defined or Object-defined error". Am lost as to how to fix this. Help please if possible. THANK YOU!
I have a named range of seven rows and three columns that I enter data into from a userform starting in the 1st row and 1st col and filling from left to right. So let’s say I’ve filled the first 5 cells. Is there a way of finding the next empty cell in the range for the next entry using a similar method to the one you use here ? Thanks.
I have tried your vba code to find the next empty cell on my workbooks but! it does not work, because my workbooks I am working on all have a combination of formatted and conditional formatting in my cells as well as I have a clear button set up to clear the contents in the range, also the copied area (range) in my workbook/sheet has formulas built in the cells, the paste option in my vba code is PasteSpecial xlPasteValues, I am using microsoft office 365 subscription, so please at your earliest convenience let me know the solution, thank you, happy new year
An amazing detailed tutorial. Thank you very much! I have a question, please: I have a table of groceries and i have a button that opens a form to add a new one with several columns (name, price, weight, place of purchase etc). ==> My question is regarding a new function (form) i want to add a "Delete Row" - By clicking a button that approves the action I want to delete Only specific collumns on the exact Row that is currently selected (skipping formulas in my sheet). On my vba code i can go to ActiveCell - but I don't know how to extract just the line number out of it.
I have tried your vba code to find the next empty cell on my workbooks but! it does not work, because my workbooks I am working on all have a combination of formatted and conditional formatting in my cells as well as I have a clear button set up to clear the contents in the range, also the copied area (range) in my workbook/sheet has formulas built in the cells, the paste option in my vba code is PasteSpecial xlPasteValues, I am using microsoft office 365 subscription, so please at your earliest convenience let me know the solution, thank you, happy new year. Ps forgot to mention the error message I get is Application-defined or object-defined error or Subscript out of range (Error 9)
Sheet11.Range("I" & Sheet11.Rows.Count).End(xlUp).Offset(1).EntireRow.Select it selects the empty row as per above code , now want put datas in that empty row as below Sheet11.Range("A").Value = Sheet13.Range("H22").Value is that correct? ( HIGHLIGHTED IN YELLOW as its not correct ) I select the entire row as want to put values in the same row B,C,D,E so on so kindly advise me Sir
Well it doesn't look correct. Post your sample code on our forum and ask there and it will be much easier to help - or post a sample file and thats even better. www.teachexcel.com/talk/microsoft-office?src=yt_comment
Thank You! Спасибо! (RUS) Graceas! (ESP) Danke! (GER) Shi-shi (CHI) Дякую! (UKR) Dziekuje! (POL) Obrigado! (POR) Hvala! (CRO) SHUKRAN (ARAB) If I would know more languages, I would continue. Really thank You. Subscription and like from me! Спасибо, братан! Salamat!
This is perfect, exactly what I was searching for and well explained. Appreciate the awesome tip!
You really save my life trying during hours to try something to find the next empty row.
Thanks !
Hi. I want that when I look for the next empty raw and type hi it will type the next number . Like 1,2,3,4,5,6, can u make it thanks
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_pinned_comment_tBXW456R6_E
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
Excellent Tutorial,Easy to Follow!Thank You Sir :):):)
Hi, thanks for the video. How to select all cell from A1 (Red) to A6 (Black) including the empty cell using VBA code?
Hi.. great.. always good to practice manipulations in VBA. Thanks and Thumbs up!
What if I need o do this on a filtered list? I need to move to the cel on the first row of a filtered list anc copy it. I tried doing it as explained in this video but I don't go to the first cell on the filtered list but to the first cell on the sheet (just below the filter row).
Great explanation! Is there a way to select all the empty cells in the worksheet and input a single value?
Hi, there are many ways to do that, one of which would be to use a loop.
Dim rng as range
Dim cell as range
Set rng = Range(put your range here)
For each cell in rng
cell.value = ...
Next cell
Thank you so much!!! I was looking for this exact thing and I will try it tomorrow.
That's EXACTLY what I needed, thanks !
Awesome video! I can’t get it to work with columns though :/ any idea?
Not without looking at a sample. Head to the Excel forum and upload a sample file along with the code that you are trying to get working and it will be easy to troubleshoot) www.teachexcel.com/talk/microsoft-office?src=yt_comment
@@TeachExcel Thank You!
Can this help to select the first empty cell in filter?
I just tried to copy data (databodyrange) from a "formatted Table" in sheet 1 and paste it into the next empty row of another "formatted Table" in sheet 2 using Range("A1").End(xlDown).Select,
It worked fine(It went right below the header), but when I try a second time with the same data set from sheet 1 using the same code I lost the last row of the 1st attempt(overwriting the last row).
Any suggestions?
it help a lot but what if i want to add border line in the selected rows
Great tutorial from you (as always :)
thanks sir I just learned something new once again Thank you very much
On a basic workbook, I tried to execute this macro: "Range (“S9”).End(xlDown).Offset(1).Select", but it came back with this error: "APPLICATION ERROR '1004' Application - defined or Object-defined error". Am lost as to how to fix this. Help please if possible. THANK YOU!
I have a named range of seven rows and three columns that I enter data into from a userform starting in the 1st row and 1st col and filling from left to right. So let’s say I’ve filled the first 5 cells. Is there a way of finding the next empty cell in the range for the next entry using a similar method to the one you use here ? Thanks.
Very Newbie here...How would you change this to find the next empty column? Thank you
A great explanation!!!
What if the data is filtered and you want to be able to paste into the next available row?
How do we set a LIMIT if we don't want it to find the next empty cell till infinity, but rather STOP at a certain finite row number? Thanks
Please any explain for Column, How to do same things in column....???
I have tried your vba code to find the next empty cell on my workbooks but! it does not work, because my workbooks I am working on all have a combination of formatted and conditional formatting in my cells as well as I have a clear button set up to clear the contents in the range, also the copied area (range) in my workbook/sheet has formulas built in the cells, the paste option in my vba code is PasteSpecial xlPasteValues, I am using microsoft office 365 subscription, so please at your earliest convenience let me know the solution, thank you, happy new year
An amazing detailed tutorial. Thank you very much!
I have a question, please:
I have a table of groceries and i have a button that opens a form to add a new one with several columns (name, price, weight, place of purchase etc).
==> My question is regarding a new function (form) i want to add a "Delete Row" -
By clicking a button that approves the action I want to delete Only specific collumns on the exact Row that is currently selected (skipping formulas in my sheet).
On my vba code i can go to ActiveCell - but I don't know how to extract just the line number out of it.
Great job
I have tried your vba code to find the next empty cell on my workbooks but! it does not work, because my workbooks I am working on all have a combination of formatted and conditional formatting in my cells as well as I have a clear button set up to clear the contents in the range, also the copied area (range) in my workbook/sheet has formulas built in the cells, the paste option in my vba code is PasteSpecial xlPasteValues, I am using microsoft office 365 subscription, so please at your earliest convenience let me know the solution, thank you, happy new year. Ps forgot to mention the error message I get is Application-defined or object-defined error or Subscript out of range (Error 9)
Thanks!
god bless me
Good video! Keep it up! Would you like to be TH-cam friends? :)
Sheet11.Range("I" & Sheet11.Rows.Count).End(xlUp).Offset(1).EntireRow.Select
it selects the empty row as per above code , now want put datas in that empty row as below
Sheet11.Range("A").Value = Sheet13.Range("H22").Value
is that correct? ( HIGHLIGHTED IN YELLOW as its not correct ) I select the entire row as want to put values in the same row B,C,D,E so on so
kindly advise me Sir
Well it doesn't look correct. Post your sample code on our forum and ask there and it will be much easier to help - or post a sample file and thats even better. www.teachexcel.com/talk/microsoft-office?src=yt_comment
@@TeachExcel Thanks for you reply sir, I just posted the sample file on your forum
Thank You!
Спасибо! (RUS)
Graceas! (ESP)
Danke! (GER)
Shi-shi (CHI)
Дякую! (UKR)
Dziekuje! (POL)
Obrigado! (POR)
Hvala! (CRO)
SHUKRAN (ARAB)
If I would know more languages, I would continue. Really thank You. Subscription and like from me!
Спасибо, братан!
Salamat!