Public Sub Combiningsheets()
Worksheets("Sheet3").Cells.Clear
Dim colBstring As String
Set colBstring = Worksheets("Sheet1").Range("B", "B").Value
'Trim (Worksheets("Sheet1").Range("B", "B").Value)
Trim (colBstring)
'do While worksheets("Sheet1").range(B:B).value <> ""
End Sub
Error : object not defined..
im tryin to trim the values in column b.....then after the trim....i wanna copy into worksheet 3....then i wanna do the same for sheet2 and copy the rest into worksheet 3..so i have a "master sheet with a combination of 1 and 2" I trim to remove garbage!!
Can someone serioulsy explain this concept of WHAT objects are and WHEN to
use then and after using them...how to access them?? thank
Bookmarks