Games4esl logo

Jobs And Occupations Worksheets

Download jobs and occupations worksheets and use them in class today. On this page, you can find a collection of PDF worksheets for teaching about jobs and occupations in English. All of these jobs worksheets are absolutely free to use in your classes. See below for the jobs and occupations worksheets currently available, and check the bottom of the page for related resources.

Jobs and Occupations Worksheets

Jobs and Occupations Worksheets

Worksheet 1

In this jobs and occupations worksheet, students are asked to read a job description and then write the correct job name in the blank space. This worksheet is great to review jobs and occupations vocabulary with beginners while also practicing reading comprehension. 

Jobs worksheet

Worksheet 2

This jobs worksheet is based on the classroom activity ‘Find Somebody Who’. Students must walk around the classroom and ask their classmates what job they want to do and why. Then they must fill in the worksheet with the details.

Jobs vocabulary worksheet

Worksheet 3

This jobs worksheet has 12 names of jobs in English. Students should read each job name and write it down 3 times. This worksheet is great for reviewing how to spell the names of jobs and occupations in English.

Jobs and occupations worksheet

Worksheet 4

To complete this jobs worksheet, students must unscramble the letters to make a job name. Then they should connect the job word to the correct occupation picture. This worksheet is useful for reviewing job vocabulary and spelling.

Worksheet 5

This worksheet asks students to rearrange the words to make a sentence. This worksheet is good for lessons teaching jobs and occupations expressions such as ‘He/She is a (doctor)’, and ‘I want to be a (firefighter).’ It is designed for beginner ESL learners.

jobs activity Worksheet

Worksheet 6

This jobs worksheet is based on the game ‘Battleships’. Students should write 10 occupations anywhere in their grid without showing their partner. These job words are the students’ ‘Battleships’. Then students will take turns trying to find their partner’s battleships by calling out the grid coordinates (e.g. B 3).  When they find one of their partner’s battleships, their partner must make a sentence using the job vocabulary in that square. For example, ‘My father is a doctor.’, ‘She’s a scientist.’, ‘I want to be a firefighter.’, etc. The first student to find all 10 job words is the winner. 

Jobs Bingo Worksheet

Worksheet 7

This jobs bingo worksheet includes 9 job pictures / words. Students should cut out the 9 pictures and then arrange them in a 3×3 grid in any order they wish. Then as the teacher calls out the job names, the students can turn that job picture over. The first student to get 1 / 2 / 3 lines of bingo is the winner. Then you can play again by asking students to turn over the pictures and make another 3×3 grid. 

Jobs and Occupations Word Search

Worksheet 8

This worksheet is a printable jobs word search. Students must find the job names in the grid and circle them.

Jobs Activity Worksheet

Worksheet 9

This worksheet is a set of activity cards for lessons about jobs and occupations. These can be used for many activities such as find your partner, memory games, bingo games, etc.

Jobs Board Game Worksheet

Worksheet 10

This last jobs worksheet is a printable board game. Each pair of students need one dice and an eraser each. To play, students should take turns rolling the dice and moving their eraser. Then the students should make a dialogue based on the job in that square. For example, “What does your father do?” – “He is a pilot.” The first student to make it to the finish line is the winner.

Related Resources

For more lesson materials for teaching about jobs and occupations in English, check out these related resouces: Jobs and Occupations Flashcards Jobs Vocabulary Guessing Game Jobs and Occupations Quiz List Of Jobs With Pictures Jobs and Occupations Lesson Plan

worksheet wb job

Lanternfish ESL Teaching Worksheets

Lanternfish ESL

A Collection of Job Worksheets for ESL

document.write(Title);

Worksheet 1: jobs and occupations crossword 1.

TA crossword that reviews many common job descriptions.

Worksheet 2: Jobs and Occupations Crossword 2

A crossword that reviews many common job descriptions.

Worksheet 3: Jobs and Occupations Crossword 3

Worksheet 4: jobs word search.

A word search that reviews common job names.

Worksheet 5: Jobs Word Search

Worksheet 6: jobs word search, flashcard set 1: jobs.

Some common jobs on large flashcards.

Flashcard Set 2: Jobs

Game 1: jobs and occupations bingo.

Review the names of many common jobs with this fun activity.

Young Learners Unit: Jobs

A collection of worksheets aimed at young learners covering jobs and job descriptions.

Game 2: Job Card Game

A card game that reviews jobs and describing jobs using relative clauses.

Game 3: Jobs Super Quiz Game

Students identify jobs by description in this quiz game.

Roleplay: Looking for Work

A roleplay where students describe jobs they saw in the newspaper to their classmates who happen to be looking for work.

Home

Reading & Math for K-5

  • Kindergarten
  • Learning numbers
  • Comparing numbers
  • Place Value
  • Roman numerals
  • Subtraction
  • Multiplication
  • Order of operations
  • Drills & practice
  • Measurement
  • Factoring & prime factors
  • Proportions
  • Shape & geometry
  • Data & graphing
  • Word problems
  • Children's stories
  • Leveled Stories
  • Context clues
  • Cause & effect
  • Compare & contrast
  • Fact vs. fiction
  • Fact vs. opinion
  • Main idea & details
  • Story elements
  • Conclusions & inferences
  • Sounds & phonics
  • Words & vocabulary
  • Reading comprehension
  • Early writing
  • Numbers & counting
  • Simple math
  • Social skills
  • Other activities
  • Dolch sight words
  • Fry sight words
  • Multiple meaning words
  • Prefixes & suffixes
  • Vocabulary cards
  • Other parts of speech
  • Punctuation
  • Capitalization
  • Narrative writing
  • Opinion writing
  • Informative writing
  • Cursive alphabet
  • Cursive letters
  • Cursive letter joins
  • Cursive words
  • Cursive sentences
  • Cursive passages
  • Grammar & Writing

Breadcrumbs

Jobs and occupation words

Vocabulary Workbook for Grade 1

Download & Print Only $4.99

Vocabulary cards & worksheets

These vocabulary cards and worksheets focus on jobs and occupation words . Each pdf includes a cut and paste vocabulary worksheet followed by a set of vocabulary cards.

worksheet wb job

Small pics:

Medium pics:

worksheet wb job

These worksheets are available to members only.

Join K5 to save time, skip ads and access more content. Learn More

What is K5?

K5 Learning offers free worksheets , flashcards  and inexpensive  workbooks  for kids in kindergarten to grade 5. Become a member  to access additional content and skip ads.

Our members helped us give away millions of worksheets last year.

We provide free educational materials to parents and teachers in over 100 countries. If you can, please consider purchasing a membership ($24/year) to support our efforts.

Members skip ads and access exclusive features.

Learn about member benefits

This content is available to members only.

  • Forgot Password?

The World Bank

Join us at the world's premier development institution!

The World Bank

Empowering Careers, Changing Lives

The World Bank

  • Diversity, Equity & Inclusion
  • Recruitment Process
  • Appointment Types

Why Work With Us?

Image

Our Mission

To end extreme poverty and boost prosperity on a livable planet.

The World Bank

Our Diversity

The World Bank is a global leader for equity, diversity, gender equality and inclusion.

Image

Global Opportunities

We offer a wide variety of job opportunities around the world, serving 189 member countries with 140 offices.

The World Bank

Our Benefits

The health and well-being of our staff is always a top priority, which is why we offer robust and comprehensive benefits.

The World Bank

Our colleagues share their experiences living our values, delivering on our mission and changing lives.

The World Bank

Explore opportunities to work alongside some of the world’s best and brightest in the development field.

The World Bank

Young Professionals Program

A competitive program for individuals with a graduate degree, professional experience and a passion for development.

The World Bank

Bank Internship Program

This program is a unique opportunity for highly motivated and innovative individuals currently pursuing a graduate degree.

The World Bank

Junior Professional Associates Program

For recent graduates, this program offers an opportunity to gain entry-level professional development experience.

Join Our Talent Networks

Stay informed of new roles, programs, and recruitment drives and become part of the World Bank Group talent community.

This site uses cookies to optimize functionality and give you the best possible experience. If you continue to navigate this website beyond this page, cookies will be placed on your browser. To learn more about cookies, click here .

Daily podcast: Severe Solar Storm Hits Earth, Causing Colorful Light Shows

Ted talks : The luminous mystery of fireflies

Audiobook: Short Stories

# Please let me know if you find a mistake or a broken link. Thanks for your support.

Grammar exercises

Vocabulary exercises

Verbs exercises

Listening exercises

Reading - exercises

Videos - lessons

Songs - nursery-rhymes

Stories - fairy-tales

Phonetic - exercises

Worksheets - handouts

English exercises

Exercises for all levels.

  • Grammar exercises - 1
  • Grammar exercises - 2
  • Vocabulary exercises - 1
  • Vocabulary exercises - 2
  • Verbs exercises - 1
  • Verbs exercises - 2
  • Phonetic symbols - exercises
  • Listening - comprehension
  • Reading - comprehension
  • Dictations: listen & write
  • Dictation exercises
  • Audio stories - fairy-tales
  • Videos - lessons - cartoons
  • Songs - nursery-rhymes.
  • Worksheets - grammar
  • Worksheets - verbs
  • Worksheets - vocabulary
  • Halloween / Christmas
  • Learning resources

Spreadsheet Planet

VBA to Add New Sheet

You can use the ‘Sheets.Add’ method in Excel VBA to add one or more sheets to a workbook.

In this tutorial, I will show you several scenarios where you can use VBA’s ‘Sheets.Add’ method to add new sheets to a workbook.

Table of Contents

The Sheets.Add Method

The ‘Sheets.Add’ method creates a new worksheet, chart sheet, or macro sheet in a workbook and makes it the active sheet. 

The syntax of the method:

expression is a variable representing a Sheets object.

The method takes four optional arguments of Variant data type, and they are described below:

Note: If you omit all four optional arguments, the ‘Sheets.Add’ method will create one new worksheet and insert it before the active sheet.

Scenario #1: Add One New Worksheet to the Current Workbook (Before the Active Sheet)

Suppose you have a workbook with three worksheets:

VBA to Add New Sheet sheets in workbook

You can use the VBA code below to add a new worksheet before the active ‘March’ worksheet:

When you run the code, it creates a new worksheet before the ‘March’ worksheet and makes it the active sheet as depicted below:

New sheet added

Note: Instead of using ‘Sheets.Add’ as shown in the example code, you can use ‘Worksheets.Add’ to achieve the same outcome.

Scenario #2: Add a Worksheet Before or After a Specific Sheet and Rename It

VBA to Add New Sheet

The VBA code below creates a new worksheet named ‘January Report’ before the ‘February’ worksheet:

When you run the code, it creates the worksheet ‘January Report’ before the ‘February’ worksheet, as depicted below:

Sheet added before a specific sheet

The VBA code checks if a worksheet named ‘February’ exists in the workbook.

If it does, it creates a new worksheet before the ‘February’ worksheet and names it ‘January Report.’ If ‘February’ doesn’t exist in the workbook, the code displays a message box indicating it couldn’t find the sheet.

Note: If you want to create a new worksheet after the target worksheet and rename it, modify the fourteenth statement of the code as follows:

Worksheets.Add(After:=Worksheets(targetSheetName)).Name = “January Report”

Scenario #3: Add a Sheet Before Or After The First Sheet in the Current Workbook

Let’s say you have a workbook with three worksheets:

VBA to Add New Sheet

You can use the VBA code below to create a new worksheet before ‘January,’ the first sheet:

When you execute the code, it creates a new worksheet at the beginning of the existing worksheets, as depicted below:

Sheet added at the beginning

The code creates a new worksheet and inserts it before the sheet with index number 1, which occupies the first position of all the existing worksheets in the current workbook.

Note: To create a new worksheet after the first sheet in the active workbook, modify the code’s second statement as follows:

Sheets.Add After:=Sheets(1)

Scenario #4: Add a Sheet After or Before the Last Sheet in the Current Workbook

VBA to Add New Sheet

You can use the VBA code below to create a new worksheet after the last sheet in the workbook:

When you run the code, it creates a new worksheet and inserts it after the last worksheet in the active workbook, as depicted below:

Sheet added at the end

The code uses the ‘Sheets.Count’ property to return the number of all sheets in the workbook.

The number returned by the ‘Sheets.Count’ property is equivalent to the index number of the last sheet in the workbook. The code creates and inserts a new worksheet after the last worksheet, the sheet with the last index number.

Note: To create a sheet before the last sheet in the workbook, you can modify the code’s second statement as follows:

Sheets.Add Before:=Sheets(Sheets.Count)

Scenario #5: Add a Sheet With a Specific Name to the Current Workbook

VBA to Add New Sheet

You can use the VBA code below to add a new sheet named ‘Summary’ to the workbook:

When you run the code, it creates a new worksheet, names it ‘Summary,’ and inserts it before the ‘March’ worksheet, as shown below:

Sheet added before a specific sheet

Scenario #6: Add a Sheet to the Current Workbook With the Name From a Cell 

Instead of hard-coding the name of a sheet, as in Scenario #5, you can let the code pick the name from a cell.

The code below adds a new worksheet to the current workbook with a name from cell A1:

When executed, the code creates a new worksheet in the active workbook using the name specified in cell A1 of the active sheet. The code handles errors for an empty cell or an invalid/existing sheet name.

Scenario #7: Add Multiple Worksheets Before the Active Sheet in the Current Workbook 

To add multiple sheets to a workbook, use the ‘Sheets.Add’ method and define the ‘Count’ parameter with the number of sheets to add.

VBA to Add New Sheet

You can use the VBA code below to create three new worksheets on the left of the ‘March’ active sheet:

When you execute the code, it adds three new worksheets to the left of the ‘March’ worksheet, as shown below:

VBA to Add New Sheet

Scenario #8: Add Multiple Worksheets to the Current Workbook With Names From a Cell Range

Suppose you have the list below on the ‘March’ worksheet of the active workbook:

List to insert sheets

You can use the following VBA code to add multiple worksheets to the current workbook, with names from the list, the cell range A1:A10:

The subroutine above initializes variables and loops through each cell in the range A1:A10 on the ‘March’ worksheet. 

The code extracts a name from each cell in the cell range. The subroutine uses the SHEETEXISTS user-defined function to check if a sheet with the extracted name already exists in the workbook.

It returns ‘True’ if the sheet exists and ‘False’ otherwise.

If the cell value is not an empty string and the sheet with a name corresponding to the cell value does not exist, the code creates a new sheet with the cell value as its name.

Note: It is crucial to ensure that the values in the cell range are valid worksheet names.

Each value should not exceed 31 characters and should not contain any of the following characters: \ (backslash), / (forward slash),? (question mark), * (asterisk), [ (left square bracket), or ] (right square bracket).

Scenario #9: Create a New Worksheet In the Current Workbook If It Doesn’t Exist 

You can prompt the user to enter a name for a new worksheet and only create it with the name provided if it doesn’t already exist in the current workbook. You can use the code below to achieve that:

The above VBA code prompts the user to input a name for the new worksheet using an input box.

If the user cancels the input box, the subroutine exits. If the user enters a name, the code checks if a worksheet with the inputted name already exists.

The code adds a new worksheet with the specified name if it doesn’t exist. If it does exist, the code displays a message box notifying the user that a worksheet with the same name already exists.

Scenario #10: Create a New Sheet in the Current Workbook Based On a Template

If you need to create a new worksheet in the current workbook based on an existing worksheet as a template, use the following code:

The above VBA code creates a new worksheet in the current workbook based on an existing template worksheet named ‘Template.’

It checks if the template worksheet exists, and if not, it displays a message box and exits the subroutine.

If the template exists, it copies it and renames the copy to ‘NewWorksheet.’

Scenario #11: Create a New Worksheet in Another Open Workbook

The VBA code below creates a new worksheet in another open workbook named ‘Sales.xlsm’ and renames it to ‘NewWorksheet.’

Scenario #12: Add A Chart Sheet to the Current Workbook

By default, the ‘Sheets.Add’ method adds a worksheet. However, to add a chart sheet dedicated to a single chart, you must define the ‘Type’ parameter with the ‘xlChart’ constant. 

The code below adds a chart sheet to the current workbook:

In this tutorial, I showed you several scenarios where you can use VBA’s ‘Sheets.Add’ method to add new sheets to a workbook. I hope you found the tutorial helpful.

Other articles you may also like:

  • What is VBA in Excel?
  • VBA Delete Files in Folder
  • VBA to Create Multiple Files in a Folder
  • How to Get Sheet Names in Excel?
  • Useful Excel VBA Macro Codes Examples

' src=

Steve Scott

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Notification Bell

Unit 9 What a job WB p 88

Loading ad...

Profile picture for user nova79

Listening and dialogue phrases

  • Google Classroom
  • Microsoft Teams
  • Download PDF

Unit 9 What a job WB p 88

IMAGES

  1. Phonic 2

    worksheet wb job

  2. Phonic 2

    worksheet wb job

  3. Work And Occupations Worksheets

    worksheet wb job

  4. ️Job Definition Match Worksheet Free Download| Gambr.co

    worksheet wb job

  5. Phonic 2

    worksheet wb job

  6. Phonics 2 : WB jobs 1+2 worksheet

    worksheet wb job

VIDEO

  1. How Narcissists Turn Your Friends and Family Again

  2. Velocity Banking Can Make You FREE!

  3. Continuous Learning For Your Success Dream Bigger

  4. Escape the Cycle: The ONLY Solution to Self-Sabotage!

  5. Grade 12 Advanced Functions

  6. कक्षा 4 -5 हिंदी वर्कबुक कार्य पत्रक 59

COMMENTS

  1. Jobs And Occupations Worksheets

    Worksheet 10. This last jobs worksheet is a printable board game. Each pair of students need one dice and an eraser each. To play, students should take turns rolling the dice and moving their eraser. Then the students should make a dialogue based on the job in that square. For example, "What does your father do?" - "He is a pilot.".

  2. PDF Lesson 1: Essential Job Vocabulary

    If an employee loses his or her job because of a neutral reason, like the company reducing its size, then we say the employee was laid off. For example, "Donna was laid off when her company started having financial problems." If you decide to leave your job, there are three verbs you can use: • I'm going to quit my job.

  3. 1,766 Jobs English ESL worksheets pdf & doc

    1,766 Jobs English ESL worksheets pdf & doc. SORT BY. Most popular. TIME PERIOD. All-time. Tobes. Jobs..Jobs...Jobs. This can be used as . 432 uses. Mishqui. Jobs +Jobs. Ws for all levels. 514 uses. Mishqui. Jobs+jobs. Sts have to commplet. 222 uses. TeacherDianaRenke. Jobs! Jobs! Jobs! Cr. A crossword puzzle d. 2227 uses. alia02. jobs ...

  4. 1,437 Jobs, work English ESL worksheets pdf & doc

    1,437 Jobs, work English ESL worksheets pdf & doc. SORT BY. Most popular. TIME PERIOD. All-time. zailda. Aren't firefighters . Another worksheet of. 128099 uses. jecika. JOBS MULTIPLE CHOICE. STUDENTS LOOK AT THE. 92355 uses. Sophie18. What job is it? Matching worksheet. 78828 uses. PhilipR. Let´s talk about WOR. This worksheet conta.

  5. RL Intermediate WB Jobs worksheet

    RL Intermediate WB Jobs RL Intermediate WB Jobs. Loading ad... Yevheniia Maliuta. Member for 1 year 4 months Age: 10-15. Level: 11. Language: ... Interactive Worksheets For Students & Teachers of all Languages and Subjects. Worksheets. Worksheets; Make Interactive Worksheets; Browse Worksheets; Wookbooks. Workbooks; Learn.

  6. Jobs Workplace ESL Activities Games Worksheets

    ESL Jobs Worksheet - Vocabulary: Unscrambling, Spelling - Elementary (A1-A2) - 20 minutes. This free jobs vocabulary worksheet helps students to practice the names of jobs and their spelling. Students have ten minutes unscramble the letters on the worksheet to form the names of jobs. Students score one point for each correct job and spelling.

  7. Jobs, occupations and professions

    Vocabulary exercises. Jobs 1 - match. Jobs 1 - listen and match. Jobs 1 - memory game. Jobs - occupations 1 - exercises. Jobs - occupations 1 - write. Jobs 2 - match. Jobs 2 - listen and match. Jobs 2 - memory game.

  8. Jobs and occupations worksheet

    Liveworksheets transforms your traditional printable worksheets into self-correcting interactive exercises that the students can do online and send to the teacher. ... English as a Second Language (ESL) (1061958) Main content: Jobs and occupations (2013222) From worksheet author: This is a simple matching exercise which can be used for revision ...

  9. Jobs and Occupations Worksheets

    This unit features worksheets and other resources for teaching about jobs and occupations. There are crosswords, word searches, and many more games for reviewing job related vocabulary. Lanternfish ESL Home. Worksheets for Young Learners. More Adult ESL Resources.

  10. Work, job, career: English ESL worksheets pdf & doc

    Work, job, career. Mirita1959. 4334. 46. 29. 0. 1/2. This is a gap-filling exercise to practise the use of the words !work, job, career" that are sometimes confusable for students. Some of the sentences have collo….

  11. Worksheets: jobs and occupations

    Worksheets: jobs, occupations and professions in English. Handouts, printable exercises pdf, videos, songs, resources.

  12. Jobs vocabulary

    ID: 7117509. 02/08/2023. Country code: MX. Country: Mexico. School subject: English as a Second Language (ESL) (1061958) Main content: Jobs and occupations (2013222) From worksheet author: Practice the basic jobs. Loading ad...

  13. Jobs and occupation words & vocabulary cards

    K5 Learning offers free worksheets, flashcards and inexpensive workbooks for kids in kindergarten to grade 5. Become a member to access additional content and skip ads. Learn jobs and occupation words with these vocabulary cards and cut and paste worksheets.

  14. PDF GET THAT JOB AND KEEP IT

    Preparing to Look for a Job 8 References 8 Background Checks 9 Drug Tests 10 The Job Hunt 10 Two-Minute Pitch 11 Job Search Websites 13 The Application Process 13 E-mail a Potential Employer 14 Fill Out an Application 14 Resume Writing 15 Writing a Cover Letter 17 Interviews and Job Fairs 19 Dressing for Interviews: Men 20

  15. Careers

    Jobs, procurement, training, and events. News; The World Bank's digital platform for live-streaming. WHO WE ARE. With 189 member countries, staff from more than 170 countries, and offices in over 130 locations, the World Bank Group is a unique global partnership: five institutions working for sustainable solutions that reduce poverty and ...

  16. English Exercises

    Vocabulary exercises - 2. Verbs exercises - 1. Verbs exercises - 2. Phonetic symbols - exercises. Listening - comprehension. Reading - comprehension. Dictations: listen & write. Dictation exercises. Audio stories - fairy-tales.

  17. PDF LEVEL 2: WORKPLACE BEHAVIOR UNIT LESSON 1: WELCOME TO ...

    Use the Power of Words Answer Key [WB.1.1.4] to guide your group discussion. Distribute any of the four Tier 1 Power of Words Worksheets [WB.1.1.1] Distribute any of the four Tier 2 Power of Words Worksheets [WB.1.1.2] Distribute any of the four Tier 3 Power of Words Worksheets [WB.1.1.3] DIFFERENTIATION T1 T2 T3 WB L1 L2 L3 L4 "Nice job ...

  18. Vocabulary: jobs worksheet

    ID: 90779. 09/04/2020. Country code: ES. Country: Spain. School subject: English as a Second Language (ESL) (1061958) Main content: Jobs and occupations (2013222) VOCABULARY ABOUT JOBS.

  19. Declaring variable workbook / Worksheet vba

    2. Third solution: I would set ws to a sheet of workbook wb as the use of Sheet("name") always refers to the active workbook, which might change as your code develops. sub kl() Dim wb As Workbook. Dim ws As Worksheet. Set wb = ActiveWorkbook. 'be aware as this might produce an error, if Shet "name" does not exist.

  20. Tutorial

    Create a workbook ¶. There is no need to create a file on the filesystem to get started with openpyxl. Just import the Workbook class and start work: >>> from openpyxl import Workbook >>> wb = Workbook() A workbook is always created with at least one worksheet. You can get it by using the Workbook.active property:

  21. python

    Use the sheetnames property: sheetnames. Returns the list of the names of worksheets in this workbook. Names are returned in the worksheets order. Type: list of strings. print (wb.sheetnames) You can also get worksheet objects from wb.worksheets: ws = wb.worksheets[0] edited Nov 21, 2018 at 14:45.

  22. VBA to Add New Sheet

    The Sheets.Add Method. Scenario #1: Add One New Worksheet to the Current Workbook (Before the Active Sheet) Scenario #2: Add a Worksheet Before or After a Specific Sheet and Rename It. Scenario #3: Add a Sheet Before Or After The First Sheet in the Current Workbook.

  23. Unit 9 What a job WB p 88 worksheet

    Liveworksheets transforms your traditional printable worksheets into self-correcting interactive exercises that the students can do online and send to the teacher. Unit 9 What a job WB p 88 worksheet | Live Worksheets

  24. trying to reference values of a range using cells

    In addition to @taller's comment: Be explicit and fully qualify all your range references, e.g. via ThisWorkbook.Worksheets("MySheet").Range(...) or by prefixing a worksheet's unique CodeName associated to your VBA project (as listed in the VB Editor's project explorer, c.f. property window (Name) as opposed to the tabular Name) like e.g ...