Hello jamiem4,
Here is one way...
![]()
With Worksheets("Sheet1").Range("C1:D1,H1:I1") .Offset(12, 0).Value = "A" .Offset(19, 0).Value = "B" .Offset(26, 0).Value = "C" .Offset(27, 0).Value = "D" .Offset(29, 0).Value = "E" End With
Hello jamiem4,
Here is one way...
![]()
With Worksheets("Sheet1").Range("C1:D1,H1:I1") .Offset(12, 0).Value = "A" .Offset(19, 0).Value = "B" .Offset(26, 0).Value = "C" .Offset(27, 0).Value = "D" .Offset(29, 0).Value = "E" End With
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks