Excel VBA - Copy Paste

Hi sir, how to disable cut copy paste and enable editing bfor particular sheet through macro code

Hi Mr.Pavan, In Copy paste macro, even if I give "TRUE" in the cutcopymode, the dancing lines gets removed. can you please share your view on this. Thank you

Sub copy_paste()
Range("a1:a10") = "CA"

'1st Method
Range("b1:b10") = Range("a1:a10").Value

'2nd Method
Range("a1:a10").Copy
Range("d1:d10").PasteSpecial
Application.CutCopyMode = True


End Sub

thank you sir it was very usefull.
if i want to sellect any rang in the sheet and past the value of specific cell to this range how could i defined the sellected range in vba ?
i can explane my question like that : i have in A1 text for example "David", I want to make a bottun with a macro that every time i sellected a rage of cells and press in the button so the macro past "David" in every cell in the rang. every time i choose defferint rang and press the putton it past David in the new range .. how the macro then looks like ? i tried to put rang(" ") or rang("?") it dosent work
pleas your worthfull help.

Thanks very much sir . Great respect for you !!!!

copy method of range class failed vba error coming when 2nd method is used

Ok

I TRY THIS BUT IT DIDN'T WORK

Microsoft Excel has stopped working Hang on white Windows reports the problem to Microshift...
Create My VBA Application Problem Sir

Thank you for your valuable information. If I will pest every 5 minutes gap than what will the code after above code. Please respond

Please share an working Excel with code

Sir, I am a new learner of VB. My question if I want to copy single cell and paste in another place based on matching data and continue till the end. How I will do that through VB? Thanks in advance.

Range is not wokring in excel

Thanks a lot. Very useful.

Now your voice is like melody in my ear.
Sometimes i just listen before sleeping. Want to see your new videos

Hi Sir, can you tell what is the limit of records when copy from one sheet to another sheet with copy and paste special one.

Hello sir

I have applied this technique for copying and pasting. My initial values to copy are obtained using some formulae. Say CO71=AH71-$CO$60, the valued is say 0.3573074. Fine. After copying this value and then pasting i should get at CV71 0.3573074. But instead i get some other value. Due shift in columns. Then how to get above exact value.

If cell contain a specific text then only copy , how can do it

Hi how can we insert row with some data in same sheet
Example
I have make a table and I want to insert same table below it by clicking one button
I hope you can answer me

gud video sir

Thank you for the session. If the rows keeps changing , is there any command , which can be used instead of the range say (A1:A10), infact automatically the macro the range from say Cell A1 till the end of the row , till where the data is reflecting. Request if you could provide your assistance. Thanks

Hi. Thanks for your work. I need help on something.
I want to create a VBA Code for a button to paste data from Clipboard on an specific cell.
Can you help?

Thanks again

hello sir, i am finding code for copy formula from one cell to end cell where ever data is available. (may be dynamic range). actually i am trying to put formula "=hour(I2)" till end of my data but range is not fix . please help

Excellent. Can you please explain how to copy values/data's from one excel file to another excel.

Any person who has any MACRO requirement. Please let me know,
Will provide you free .

You explained this concept so easy way. I'm facing so much difficulty to learn VBA. Thanks a lot sir. 🙏

Instead of defining the range like Range("a1:a10"), how to define the macro automatically copy till the last entry?

Can I use this method to copy text paragraphs in a word document to clipboard? if yes how?

Hi guys what did you think about to create a watsapp group with the teacher to help each other to create programs

sir kindly help me
how to create a sort command using vb
and pls give me ur whatsapp no

The VBA coms too difficult but Now it's coming to me naturally. Wonderful teacher I appreciated

Dear Sir,
Want transfer data from one workbook to another.
Workbook - A
1. Receipt No.
2. Date
3. Name
4. Amount
To Workbook - B in two different Sheets
can you please help to write correct VBA code.

I have a work book having 140 sheets and a master sheet. In master sheet I have data in a column which I want to paste each cell data into those 140 sheets in a specific cell. can you please help me

how to use autohotkey to copy from excel from each cell and paste to someother programm.

If I have copy a1 to a1 1

Then I want to paste into only
A2 to A3

How it was done
Range I want flexible
A2 To A4 Or A5
Perticler range I have put into Cell c1
Like
4 (Copy Into Just 4Cell)
Or
I have mention it like in cell c1
(A2:A15)

Sir, I have a problem coding in Excel VBA, which needs your guidance.
When executing a macro with the command button in Excel, an error occurs while copying and pasting the formula via VB code.
I want the VB code to run and the previous line formula to be pasted into the next line and the formula to be hidden and protected without any errors. While the rest of the cells remain unprotected for data entry.
Can you guide me in this regard?

how to copy and paste data from excel to website ???

sir what is the use of using VBA when we can record a macro?

How to paste either no of ROWS below or above ? Example I paste 5 items already second time I past it should paste without overwriting the date I have already pasted instead it should paste either below or above no of preferred ROWS
kindly explain sir

you are the best

Hi sir... I need some help in copy and paste the same above data in next empty cell... Using vba... Can u please help me🙏.
It's really urgent for me... Please sir

Sir I am getting this error, pl confirm the meaning " Be careful! parts of your document may include personal information that cant'be remove by the document inspector????

Nice way of presentation. Sooper

Really great Great!!! whenever i try to learn something about excel problem ,i just open the tutorial of pavan lalwani

Sir your platform is very good. I always learn to easily and fast, and also your teaching is very very good.

I m getting a error while writing a code for ex application.cutcopymode=false.
Can anyone explain why it is coming?

Sir xl me sheet1 ki 1 hi row me jo data hai us data me ham jo bhi box select Karen uski value ko vba ke dwara kise dusri row me copy paste Karen
Sir plz reply

Sir,how to check for matching cells in different sheets using macros? Please help..

Please provide your email I'd

Proper way of teaching_Very easy to understand