Question: I need to write Macro, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting

I need to write Macro, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees should have a hiring date between 1/1/1985 and 1/1/1990, both dates inclusive. (Hint: For dates, use # signs, example, #1/1/1985#) (Must use Do-Until loop).

Can I get some help on how to do this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees...

4. Write (not record) a Macro, QUESTION4 , that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees...

4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees...

Write (not record) a Macro, QUESTION4, that will highlight records in blue color (Colorindex =5 ) with all employees that are either in Marketing or Accounting departments and those employees should...

No looping/iterations please. Create a new Excel Workbook named yourlastName P3.xlsm (replacing yourlastName with-your last namel) and write the VBA code to estimate employee P3.xism( payroll...

Describe the types of cybercrimes facing organizations and critical infrastructures, explain the motives of cybercriminals, and evaluate the financial Explain both low-tech and high-tech methods...

I need help with this assignment Can you Answer: 3b, 3c, 4a, and 4b thank you Apollo Internal Controls Audit Mini Case In this mini-case you will perform some internal control testing procedures...

Please answer all the questions 3b, 3c, 4a, and 4b and write the comments Apollo Shoes, Inc. Consideration of Fraud Memo December 31, 2020 We identified the following key risk factors: 1) Significant...

Write an engagement letter of no more than 1,050 words for a Section 404 audit of Apollo Shoes. Assume that Apollo Shoes is a publicly traded company for which the SEC requires an audit of internal...

Columbus Custom Carpentry - Active Employees First N Last NaSexAge EEO FT/PT Anthony Chad Jeffrey Molly Daniel Brook James Brian Scott Ronnie Terry Stephen Benny Don Roger Christop Raven Brian Nikki...

The Los Angeles Times (June 14, 1995) reported that the U.S. Postal Service is getting speedier, with higher overnight on-time delivery rates than in the past. Postal Service standards call for...

Discuss ethical consideration for banks, regualtors and customers in the uk during the Covid19 pandameic.

For 2 0 2 4 , the AGI threshold for the deductibility of eligible personal casualty losses generally is: Multiple Choice 1 0 % . 5 % . 2 % . 7 . 5 % .

Use the data set to find the sampling mean, sample standard deviation, and construct a 99% confidence interval for the population mean. Assume the population is normally distributed. SAT Scores The...