Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using Trim function in Excel
I am trying to trim excess spaces off a range of cell values. I am using the following code with no luck: Option Explicit Dim i As Integer, j As Integer, Shit As String Sub FixIt() For j = 1 To 12 For i = 1 To 32 Shit = Cells(i, j).Value Trim (Shit) Next i Next j End...- mjmacarty
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using Trim function
I am trying to trim excess spaces off a range of cell values. I am using the following code with no luck: Option Explicit Dim i As Integer, j As Integer, Shit As String Sub FixIt() For j = 1 To 12 For i = 1 To 32 Shit = Cells(i, j).Value Trim (Shit) Next i Next j End...- mjmacarty
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Using VBA to select characters from a cell range
I am trying to assign the first three characters of cell range to a variable. I would then like to copy and paste these characters into another cell range. Can't seem to do it! I have tried using both string and characters variable declarations. I am a novice though can someone help?- mjmacarty
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
