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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Assign value to named range.
Did you try to prefix the cell name with its objectname such as ActiveSheet or SheetX or whatever? or to use the extended definition Range("AmountOwing")? HTH Luca- palusa
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Display the size of the active file
Hi, try this. Under Excel sheet open the VisualBasic Editor (Alt F11). In the General Declaration panel paste this code: Public Declare Function FindFirstFile Lib "kernel32" Alias "FindFirstFileA" _ (ByVal lpFileName As String, lpFindFileData As WIN32_FIND_DATA) As Long Public Type FILETIME...- palusa
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Imported data to excel - need to remove the boxes
Hi, I presume that the "boxes" are non printable ascii characters, such as CHR$(10), suffixed to your text data. If they are in your sheet cells, e.g. C1, you can remove inserting in a cell, e.g. A1, the formula =left(A1, len(A1)-1) HTH. _LF- palusa
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
