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