|
Range Name issue
I have created a named range with a single value in it and I can't seem to
access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
Range Name issue
The range name definition is
=SUM(Defectives)/SUM(Opportunities) If that helps at all. "Barb Reinhardt" wrote: I have created a named range with a single value in it and I can't seem to access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
Range Name issue
to access a named range w/code use the following:
for accessing on an active sheet Range("MyRange").Value access a range on a specific sheet Range("Sheet1!MyRange").Value access a range in another open workbook Range("[Book1.xls]MyRange").Value access a range on a specific sheet in another workbook Range("[Book1.xls]Sheet1!MyRange").Value Hope this helps Sandy Barb Reinhardt wrote: I have created a named range with a single value in it and I can't seem to access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
Range Name issue
use Application.Evaluate("P_bar")
-- Haldun Alay "Barb Reinhardt" , haber iletisinde şunları ... I have created a named range with a single value in it and I can't seem to access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
Range Name issue
to access a named range w/code use the following:
for accessing on an active sheet Range("MyRange").Value access a range on a specific sheet Range("Sheet1!MyRange").Value access a range in another open workbook Range("[Book1.xls]MyRange").Value access a range on a specific sheet in another workbook Range("[Book1.xls]Sheet1!MyRange").Value Hope this helps Sandy Barb Reinhardt wrote: I have created a named range with a single value in it and I can't seem to access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
Range Name issue
to access a named range w/code use the following:
for accessing on an active sheet Range("MyRange").Value access a range on a specific sheet Range("Sheet1!MyRange").Value access a range in another open workbook Range("[Book1.xls]MyRange").Value access a range on a specific sheet in another workbook Range("[Book1.xls]Sheet1!MyRange").Value Hope this helps Sandy Barb Reinhardt wrote: I have created a named range with a single value in it and I can't seem to access it within my VBA code. This is what I have so far. I've put it in a debug.print statement to see if I can see what's going on and it gacks each time. Debug.Print Range("P_bar").Text Debug.Print Range("P_bar").Value I get a Runtime error '1004' Method 'range' of object '_Global' failed. I can access the named range from the worksheet, just not the macro. The named range is a workbook range, not a worksheet range. Thanks, |
| All times are GMT +1. The time now is 09:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com