Excel VBA - Paste Special

Поділитися
Вставка
  • Опубліковано 19 січ 2025

КОМЕНТАРІ • 49

  • @TutorialsPoint_
    @TutorialsPoint_  Рік тому

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

  • @vaigunthrey9228
    @vaigunthrey9228 4 роки тому +11

    give this man an award , completely in love with this playlist

  • @yashzaveri7684
    @yashzaveri7684 2 роки тому +3

    Hats off to such great teachers you are taking such heavy efforts to spread knowledge

  • @ashokchakravarti6111
    @ashokchakravarti6111 2 роки тому

    If someone wants to learn from the scratch he is the right tutor... Thank you so much pawan sir...

  • @MultiBodmin
    @MultiBodmin 2 роки тому

    Very good. I really enjoyed the presentation and I was surprised what I got to take away. The extras were very useful. I also wanted to point out that I was impressed with the touching of the large screen and the computer responded, very very sweet.

  • @anisurrahman8551
    @anisurrahman8551 4 роки тому

    **Excellent** Nice Video. Thank you very much. Its functioning very well in my program.

  • @floviXperia
    @floviXperia 4 роки тому

    Awesome tut! Great help! ✨ Thank you so much for this! 👍🏻👍🏻

  • @harshit9005
    @harshit9005 3 роки тому

    Very nice explaination too helping thank you so much

  • @darshanshah2506
    @darshanshah2506 3 роки тому

    Love this channel ❤

  • @AshrafAli-ih4oy
    @AshrafAli-ih4oy 4 роки тому

    thanks for the video bro. It's really helpful

  • @PriyaPriya-fl7cr
    @PriyaPriya-fl7cr 6 років тому +1

    Well explained... Thanks for the video

  • @lookingforwardto
    @lookingforwardto Рік тому

    it's a nice presentation. I would like to work on excel with you, to enhance my knowledge.

  • @farhakhan2028
    @farhakhan2028 5 років тому +1

    thankyou so much..very well explained...plz can u upload the excel sheets of all these 100 examples

  • @mohitgola
    @mohitgola 6 років тому +1

    You have not used "=" before xlpaste and other commands. Can you please suggest when should we use "=" and when to not? Also when to use .Value and when not to use?

  • @sateeshgowd675
    @sateeshgowd675 6 років тому +1

    Awesome explain

  • @dankshavalishaik3313
    @dankshavalishaik3313 4 роки тому +2

    sir can we write in this format
    [a1:a10].copy
    [b1:b10].pastespecial.
    I have tried a couple of times. for most of the options, it's working. but for copy-paste, they aren't working. can you explain?

  • @esthern9161
    @esthern9161 Рік тому

    Hi,could you plz advise how to convert a specific Excel worksheeet into CSV file and keep its number format and column width same using vba

  • @anandsharma2430
    @anandsharma2430 3 роки тому

    Pavanji it's too good but only working in 1 Excel file, if used in other files showing some global variable error

  • @Danny-Do-It
    @Danny-Do-It Рік тому

    How can you restrict users to only be able to paste special in cells? I dont want users changing the font, formatting or anything of a cell. I only want them to be able to enter values. What is the point of cell protection.. if you cant stop users overwriting the font size and formatting? Please help me I am stuck

  • @NishantSingh-qf4bf
    @NishantSingh-qf4bf 4 роки тому +1

    My paste special tool is disables and not enabling what to do?

  • @aadilsaiyed9734
    @aadilsaiyed9734 3 роки тому

    Can it copy the cell where the cursor is and past it in a particular cell?

  • @deepakvaishy7754
    @deepakvaishy7754 3 роки тому

    You are just great

  • @argenisaguilar9045
    @argenisaguilar9045 8 місяців тому

    Thank you very much...

  • @reignrelic
    @reignrelic 6 років тому +1

    I don’t get that paste special box. :( what could i do?

  • @Atharvao988
    @Atharvao988 2 роки тому

    very nice tutorials, way of explaining each topic is excellent.
    But I have some problem in my project ,Micros are disabled. I took online help, AND DO ALL THE STEPS they told like go file-->option->trust center-->trust center setting-->micro setting-->enable all micros.
    But when I create micro and try to run It still give me same error i.e MICROS IN THIS PROJECT ARE DISABLE. Now what I have to do?

  • @sandeepkothari5000
    @sandeepkothari5000 6 років тому

    Great show! Please share your finished worksheet.

  • @smarttechno2203
    @smarttechno2203 4 роки тому

    if another sheet copy then what will be the code

  • @filipecoutinho7192
    @filipecoutinho7192 6 років тому

    Very nicely explained. Do you have a CD to learn Ms Excel Vba. I can't attend classes

  • @jaswantdn7
    @jaswantdn7 6 років тому +1

    super sir..

  • @harishramesh1351
    @harishramesh1351 4 роки тому

    While writing macro...when i type paste special it doesn't show recommendations for paste special.
    How to activate it?....

  • @sunilnomula2682
    @sunilnomula2682 5 років тому

    Sir, I had same data which is in paste special - values only..
    Is that there any chance to get same data with formulas..

  • @vkp526
    @vkp526 5 років тому

    sir,
    autofilter apne cover ni kia with wild char like filter contain....

  • @soumyanayak2898
    @soumyanayak2898 5 років тому

    how to get double underline?
    will it be within font block or border block?

    • @ankursharma6157
      @ankursharma6157 5 років тому

      Hi Soumya,
      - click on Home tab
      - go to Font group
      - next to Underline option, click on drop-down
      1st option is) Underline
      2nd options is) Double Underline
      Hope, this helps.

  • @SRIDHARGsridharganja
    @SRIDHARGsridharganja 3 роки тому

    Hi can you tell me how paste in next row

  • @kanukollusrinivas6653
    @kanukollusrinivas6653 4 роки тому

    Sir, how to convert from Vertical to horizental through VBA MACRO

  • @AlbaLuna-u5i
    @AlbaLuna-u5i 2 роки тому

    Thank you!

  • @naveenofficial3680
    @naveenofficial3680 4 роки тому

    How to PasteSpecial Operation Add in VBA to convert text into number?? Plzzz help sir

  • @bhawnamishra4454
    @bhawnamishra4454 6 років тому +1

    Do u have you institute in delhi? I want to learn from you

  • @arifenigineer
    @arifenigineer 6 років тому

    Great !

  • @kumarrohit8538
    @kumarrohit8538 6 років тому +1

    super

  • @bengalwrrir1375
    @bengalwrrir1375 2 роки тому

    Hello sir.... I want yr help can u help me.... Please tell me... @tutorials point

  • @Roymanihuruk
    @Roymanihuruk 6 років тому

    Can be given script for text box control, after run text in text box, the result is not different from text box, my problem is in multi-line suda control text box, but when sent the result so enter (VbcrLf) or new Line, I requires in function text box control (Alt + Enter) Or Shift + Enter runs so that the text you want to send has a new paragraph in the same line in the text box
    Please help me

    • @humanrights2531
      @humanrights2531 5 років тому

      Hi Sir!
      Please watch, subscribe and share our Channel. We create amazing things via Excel

  • @Kuttieschuttis
    @Kuttieschuttis 5 років тому

    Dear Sir,
    kindly send me the excel file what you are used to explain in youtube (100 formula file)

  • @irfanzaman1
    @irfanzaman1 6 років тому

    vba code book

  • @kerssful
    @kerssful 2 роки тому

    thank you!