Thread
:
Assign Cell Values without a Loop
View Single Post
#
3
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_564_]
external usenet poster
Posts: 1
Assign Cell Values without a Loop
Range("B2:10").value = "abc"
Typo alert... Bob accidentally left out the column designation for the
ending cell of the range...
Range("B2:E10").Value = "abc"
Rick
Reply With Quote
Rick Rothstein \(MVP - VB\)[_564_]
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)[_564_]
Assign Cell Values without a Loop