Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
help on range and Name object in excel
Hi SkipVought thanx for your promt reply. I really appreciate it. but excel still throws an error. The answer to your questions are : i = 1 to [Augdelta120].Columns.Count j =1 ( which I had not defined earlier ) [Augdelta120](j, k).Value = (([julydelta500](j, k).Value) -...- pdp2907
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
help on range and Name object in excel
Hi I Named a cell range in Excel sheet using the Name command as follows: Names.Add Name:="Augdelta120", RefersTo:="Sheet1!$B$6:$M$6" Names.Add Name:="julydelta500", RefersTo:="=Sheet18!$B$5:$M$5" For i = 1 To Augdelta120.Columns.Count...- pdp2907
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
