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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: csmithwick
- Order by date
-
Remove "=" from cell with VBA in Excel
Change your code to the below: (adding a ' character at the beginning of a cell's content tells Excel to treat everything after it as text - the ' won't display) col_FacID = FindColumn(str_FacID, .Range("A1:Z1")) Dim Variant_FacID As Variant Columns(col_FacID).Select...- csmithwick
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
