Excel an......Range("name").Value = "whatever" 
Author Message
 Excel an......Range("name").Value = "whatever"



Quote:

> Hi

> i am trying to access a cell in an excell spreadsheet using vb code. i
> want to access the cell by the cell name and not by its index location.
> for example, i dont want to use this method:

> XL.Cells(6, 5).Font.Bold = True
> XL.Cells(6, 6).Interior.Color = &HFF00
> XL.Cells(6, 7).Borders(xlEdgeBottom).Weight = xlHairline
> XL.Cells(6, 8).Borders(xlEdgeLeft).Weight = xlHairline
> XL.Cells(6, 9).Borders(xlEdgeRight).Weight = xlHairline

> i want to access it by the name which i gave the cell. this is very
> important incase the cell is updated with new rows or columns. i need to
> access the cells by the name which i assigned it. please let me know if
> there is any way of doing this in vb.

> many thanks
> pat



Fri, 15 Aug 2003 10:09:15 GMT  
 Excel an......Range("name").Value = "whatever"
Try XL.Range("YouNameGoesHere")...

(this works in VBA, so I'm making a guess here...


Quote:



> > Hi

> > i am trying to access a cell in an excell spreadsheet using vb code. i
> > want to access the cell by the cell name and not by its index location.
> > for example, i dont want to use this method:

> > XL.Cells(6, 5).Font.Bold = True
> > XL.Cells(6, 6).Interior.Color = &HFF00
> > XL.Cells(6, 7).Borders(xlEdgeBottom).Weight = xlHairline
> > XL.Cells(6, 8).Borders(xlEdgeLeft).Weight = xlHairline
> > XL.Cells(6, 9).Borders(xlEdgeRight).Weight = xlHairline

> > i want to access it by the name which i gave the cell. this is very
> > important incase the cell is updated with new rows or columns. i need to
> > access the cells by the name which i assigned it. please let me know if
> > there is any way of doing this in vb.

> > many thanks
> > pat



Fri, 22 Aug 2003 10:18:15 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. GetObject("","InternetExplorer.Application") fails in Excel VBA

2. CreateObject("Excel","//server"), MsgBox output

3. CreateObject("Excel","//server"), MsgBox output

4. GetObject("","InternetExplorer.Application") fails in Excel VBA

5. *"*-.,._,.-*"* I"LL TRADE VISUAL C++ FOR VBASIC *"*-.,_,.-*"*

6. "subscript out of range" - Excel

7. <IMG ALT="whatever" src="whatever.gif"> tag

8. SysCmd 603, "path","path"

9. Disabling "BACK"/"FORWARD" buttons

10. Loop print "VARIABLE", "VARIABLE"

11. DLL or something like "#"#ยค#"!"#

12. Disabling "BACK"/"FORWARD" buttons

 

 
Powered by phpBB® Forum Software