Get Certified in Excel VBA:bit.ly/41fWeVP Use coupon "KZread12" to get ‘’FLAT 12%’’ OFF at Checkout.

What an effort that you've done. That touch screen man. Great job

Dear Pavan Lalwani , You are The best for Beginners Bcz your videos' easy to understand and its step by step...Nice Presentation. Thanks®ards, Nikil Kumar C

Thanks. Very good presentation.

Thanks for easy presentation.

Very Nice Presentation...

great work Thank you !

Thank you!!

Thanks Tutorials Point!!! Q: How to delete a range of cells without shifting them up? (similar to what you taught in first code but for a range of cells)

@mohittiwari111

5 жыл бұрын

Range("a1:a10").Clear

@ilkergencel9800

2 жыл бұрын

similar question I have, in a table I found the last empty cell with the code below ActiveSheet.Range("c8").End(xlDown).Offset(1, 0).Select starting from that cell below following cells (maybe 10 or 20) I want to delete rows. Can you please advise?

Thanks

Sir it is possible to delete cell based on criteria. Not the entire row

when i delete a cell through vba, it shifts cells to the left instead of shifting cells up, how to choose the direction of shifting of cells in vba? i have cells(i,j).delete shift:= xltoleft option only i dont have cells(i,j).delete shift:= xltoup option why?

How to delete a range of cells with shifting cells up?

Hi. I would like to ask if I want to delete only specific range, excluding the 1st row (header), how is this done? Thanks

@CRG_

4 жыл бұрын

Rui Ystrella range (“a2:c12”).delete ?

Hi, can I ask a question about excel vba code? if possible

while deleting, why the cells are shifting from one row to other row. kindly help me on this.

'My Reference Range("A1").Delete ' SHIFT Range("C1:C4").EntireColumn.Delete Range("C1:C4").EntireRow.Delete

Can you please tell me the difference between clearing a cell and deleting a cell (if the is any)?

@anubhavsingh4210

4 жыл бұрын

clear mean just clear all the format, data, or anything in that particular cell but delete cell means you delete that particular cell let me know if you need me more or you can contact me on 8076032584.

@sujeshsingh2511

4 жыл бұрын

when you clear cell, the reference of the adjacent cell does not change but when you do delete the cell the reference of the adjacent cell change.

Sir, What should I do if I need to delete Range("A1:A10") and the cells should shift up?

@indiantech9979

4 жыл бұрын

No

@indiantech9979

4 жыл бұрын

Its Delete A1 to A10 only

@pralaydutta166

3 жыл бұрын

Range("A2:A10").Delete shift:=xlUp

@dileep.ramagiri

3 жыл бұрын

Range("a1:a10").Delete shift: = xlUp

Sir.. can I know macro for finding words that are captured in different ways

@prashantham3832

3 жыл бұрын

In a column

how to delete cells with shift cells left?

i am a genius in computer

My laptop is showing 438 error any one please help