troubleshooting Question

Number format VBA to two different tabs in workbook

Avatar of LUIS FREUND
LUIS FREUND asked on
Microsoft OfficeVBAMicrosoft Excel
5 Comments1 Solution133 ViewsLast Modified:
How can I apply this number format code to different sheets:

On "MAIN_PN" tab I have this code that works great But I need to apply it to "MAIN" tab O27:O30 as well.

Sub FixDates()
   Columns("I").TextToColumns
   Range("I4:J650", Cells(Rows.Count, "I").End(xlUp)).NumberFormat = "mm/dd/yy"
End Sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros