| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking and setting a value to a range in VBA
Greetings,
I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
On May 1, 11:54*am, LetMeDoIt wrote:
Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). Or alternatively, I'd like to dynamically set that range to soemthing specific, like: "sheet1!$B$10:$B$30" I'm using excel 2003. Many thanks. CG |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
Try
iRow = range("MyRange").row -- HTH... Jim Thomlinson "LetMeDoIt" wrote: Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
On May 1, 12:12*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: Try iRow = range("MyRange").row -- HTH... Jim Thomlinson "LetMeDoIt" wrote: Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG- Hide quoted text - - Show quoted text - hhhmmm, but I need to set the range, like something like "sheet1! B10:B30" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
hhhmmm, but I need to set the range, like something like
"sheet1!B10:B30" Try it this way... Names("MyRange").RefersTo = "=Sheet1!$B$10:$B$30" -- Rick (MVP - Excel) "LetMeDoIt" wrote in message ... On May 1, 12:12 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: Try iRow = range("MyRange").row -- HTH... Jim Thomlinson "LetMeDoIt" wrote: Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG- Hide quoted text - - Show quoted text - hhhmmm, but I need to set the range, like something like "sheet1! B10:B30" |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
On May 1, 1:58*pm, "Rick Rothstein"
wrote: hhhmmm, but I need to set the range, like something like "sheet1!B10:B30" Try it this way... Names("MyRange").RefersTo = "=Sheet1!$B$10:$B$30" -- Rick (MVP - Excel) "LetMeDoIt" wrote in message ... On May 1, 12:12 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: Try iRow = range("MyRange").row -- HTH... Jim Thomlinson "LetMeDoIt" wrote: Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG- Hide quoted text - - Show quoted text - hhhmmm, but I need to set the range, like something like "sheet1! B10:B30"- Hide quoted text - - Show quoted text - I'm getting "application-defined or object-defined error". I'm using office 2003. Can that be an issue? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checking and setting a value to a range in VBA
On May 1, 1:58*pm, "Rick Rothstein"
wrote: hhhmmm, but I need to set the range, like something like "sheet1!B10:B30" Try it this way... Names("MyRange").RefersTo = "=Sheet1!$B$10:$B$30" -- Rick (MVP - Excel) "LetMeDoIt" wrote in message ... On May 1, 12:12 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: Try iRow = range("MyRange").row -- HTH... Jim Thomlinson "LetMeDoIt" wrote: Greetings, I'm trying to do an easy thing (I think) but have not succeeded thus far. I created a name range manually in a spreadsheet, but need to check via VBA code for the value of that range, then if it changed to its default, reset that range to a specific value. To check the that the row has not changed, I do the following: iRow = Range("=MyRange").Row and thus if this is not my original value, I reassigned it ( this is where I'm getting an error msg in the code). I'm using excel 2003. Many thanks. CG- Hide quoted text - - Show quoted text - hhhmmm, but I need to set the range, like something like "sheet1! B10:B30"- Hide quoted text - - Show quoted text - never mind... i added application. in front of your statement, and it's working like a charm. Many thanks for your help. CG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking a range for at least one | Excel Programming | |||
| Checking a range with IF | Excel Discussion (Misc queries) | |||
| Checking range of cells for entry then checking for total | Excel Programming | |||
| Checking/Setting a reference on open | Excel Programming | |||
| checking if a range has a name. | Excel Programming | |||
Linear Mode
