Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
This is part of a much larger procedure that works fine, and even this part works OK if I hard code the column address into it, but the last column may change in the future.
'remove dashes from part numbers on DSV base data sheet 'first get the last column LCDSV = WS3.Cells(1, Columns.Count).End(xlToLeft).Column 'then remove dashes WS3.Range("A1:" & LCDSV & "1").Replace What:="-", Replacement:="", SearchOrder:=xlByColumns, MatchCase:=True
|Excel: Comparing the Values in One Column with the Values in Another||2||30|
|Copy a row in MS Access but with some field values changed||8||27|
|Find the last position of specific character in a cell Excel||7||33|
|Quickbooks - Merging data||3||8|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!