Range References in vba
I have 2 named cells say, tStart and tEnd - If I wanted to set the
contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a side issue, is it possible to get cell references from a named cell/Range in some way ? Thanks for any illumination Regards |
Range References in vba
Try
With Sheet4 .Range(.Range("tStart"),.Range("tEnd")).Value = "Temp" End With -- HTH Bob "Isis" wrote in message ... I have 2 named cells say, tStart and tEnd - If I wanted to set the contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a side issue, is it possible to get cell references from a named cell/Range in some way ? Thanks for any illumination Regards |
Range References in vba
Use a comma so seperate the names, not a colon.
Sheet4.Range("tStart","tEnd").Value = "Temp" -- Best Regards, Luke M "Isis" wrote in message ... I have 2 named cells say, tStart and tEnd - If I wanted to set the contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a side issue, is it possible to get cell references from a named cell/Range in some way ? Thanks for any illumination Regards |
Range References in vba
hi
on the side issue, something like this might work MsgBox Range("tStart:tEnd").Address or for a range MsgBox Range("myRange").Address regards FSt1 "Isis" wrote: I have 2 named cells say, tStart and tEnd - If I wanted to set the contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a side issue, is it possible to get cell references from a named cell/Range in some way ? Thanks for any illumination Regards . |
All times are GMT +1. The time now is 08:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com