troubleshooting Question

Select 1 Row Of A Named Range

Avatar of qholmberg
qholmberg asked on
Microsoft ExcelVB Script
6 Comments2 Solutions433 ViewsLast Modified:
I have a named range, Operations. It is located on the sheet at I5:N25. I am using VBA to loop through each row of that named range filling formulas that refer to other sheets in the workbook. At the end of each row integration, I would like to change the .style attribute to a style I have defined in the workbook.

This would seem like a simple operation to me but I cannot figure out how to zero in on just the current row I'm of Operations I'm working in within the boundary's of I:N columns. The boundary of I:N will change as time goes on so it generalized so it takes the everything between the left and right outside boundaries.

I can get to the row. I just need the statement(s) that will reference everything in that row within named range.

NorieAnalyst Assistant
Join our community to see this answer!
Unlock 2 Answers and 6 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 2 Answers and 6 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