Thread
:
bug in excel range naming?
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 129
bug in excel range naming?
works for me.
Sub f()
Dim b As Workbook
Dim s As Worksheet
Set b = ThisWorkbook
Set s = b.Sheets("Sheet1")
s.Range(s.Cells(1, 1), s.Cells(1, 256)).Value = "abc"
End Sub
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]