Upskill Technologies 

A springboard to Success

  • UpskillTechnologies

  • Corporate Training

  • Online Training

  • Classroom Training

  • Consulting

  • Blog

  • Contact

  • Student

  • Forum

  • Members

  • More

    To see this working, head to your live site.
    1. Upskill Technologies
    Search

    UpskillTechnologies Forum

    A forum to discuss and brainstorm any issues or ideas on Excel, VBA and Access.

    Excel Forum

    Get all your excel queries or ideas answered. Discuss all the help for formulas, reports, charts, pivots....
    Views 
    Posts1

    VBA Forum

    Lets discuss VBA coding ideas and help each other to make better automation
    Views 
    Posts1
    New Posts
    • Admin
      Jul 29, 2018
      Selecting range in VBA
      Discussion 
      Hi there- In VBA for excel selecting a range can be done in many different ways. Like if you want to select a cell a1 then the code is Range("a1").select. If you want to select a group of cells like say cells starting from a1 to a10 then the code would be Range("a1","a10").select. Although this can also be written as Range("a1:a10").select. Now this was for a continuous range of data but if you want non continuous range to select then we can use something like this Range("a1,a3,a10,c10").select. Finally if you like to select the entire sheet cells then the syntax you can use is cells.select. Well if you guys know you can contribute the code to select a row, column, multiple rows, multiple column and so on...
      0 comments0
      0
    • Admin
      Jul 29, 2018
      Most Common Excel Shortucts
      Discussion 
      Though there are many shortcuts in excel but I would like to start a discussion to see which do you all consider as the most useful shortcuts in excel. To start with I use Ctrl+C and ALT+E+S+V a lot may be like 100 times a day for doing analysis or making reports. Also the shortcut to filter which Alt+D+F+F is also a major one which I use a lot; the same can be used to remove filter. Alright so now let's see what all you guys use a lot.
      0 comments0
      0
    Excel Jobs
    VBA Jobs
    Interview Questions
    Downloads
    Automation Consulting
    GST Software
    Recruitment
    Resume Writing Services
    On Job Support
    Like us on facebook
    Excel Video Playlist
    Exercises
    • facebook-square
    • Twitter Square
    • Google Square
    • whatsapp2

    For Enquiries drop an email at info@upskilltechnologies.com or call/whatsapp/snapchat at +91-9985130004