defining a range in VBA

  • Thread starter Thread starter chloe98
  • Start date Start date
C

chloe98

I am trying to define a range in VBA with the code

Dim rngResults As Range
Set rngResults = Worksheets("111").Range("i45:n45")


However this does not appear to be working. Am I doing somethin
wrong? This code is inside that same workbook as the range I'm tryin
to create.

Thank
 
It was an out of context error, according to my debugger. As long as m
code is in the same workbook as the range I'm defining, I wouldn'
think that this would be a problem. Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel VBA setting Ranges 2
Excel VBA - Problem with Closing Print Preview 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA set thick borders around non empty cells in range 0
Define Name range 10
Excel VBA - counting cells by colors and names to it in two different rows. 0
I need help with this program written in Visual Basic for Excel 2007. 4

Back
Top