Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to TRIM data <--Rookie here :o)
Hello -
I would like to use the Trim function on column C for a worksheet called "ODBC Updates." Here is the begining of my code, but I can't figure out how to call out to this other worksheet and make the Trim command work. Can anyone please assist me? I've labeled a section 'Trim UPC's on ODBC Updates' as I think that is where this command should fit. Thanks! Dan Sub JCW_Refresh() ' Copy Current Case Price into Prior Case Price Range("H5").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Range("G5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ' Refresh the hidden "ODBC Updates" worksheet with current data Sheets("ODBC Updates").QueryTables(1).Refresh _ BackgroundQuery:=False ' Trim UPC's on ODBC Updates ' (What do I put here??) ' Copy hidden Current Case Price into visible Current Case Price Range("J5").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Range("H5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim data in Excel 2003 | Excel Discussion (Misc queries) | |||
Trim and Keep the Trimmed Data | Excel Worksheet Functions | |||
Trim Data in a Query | Excel Programming | |||
Trim data in charts | Charts and Charting in Excel | |||
VBA Trim and Application.worksheetfunction.Trim | Excel Programming |