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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA Search cell help
Hello, I am wondering if anyone has a script that will look for the contents of one cell in a list of other cells. For example: In cell C2 I have a 10 digit phone number. In column E, I have a list of phone numbers ranging from E2:E100. What I would like to do is take the number in C2 and look...- chadbi
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Referencing a cell for Do until Loop
Hello, I have this do until loop in my script: '========================================================= Range(cellchoice).Select Do Until ActiveCell.Value = Empty ActiveCell.Offset(0, 29).Value = RandomNumber ActiveCell.Offset(1, 0).Select Randomize...- chadbi
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Invalid Procedure call or argument error for objFso.CopyFolder
I have this script and I am getting an error when trying to move the folders to the new location...anyone have any suggestions? '================================================ 'Option Explicit 'On Error Resume next Dim objNetwork Dim objFso Dim objFolder Dim FromShare Set objFso =... -
VBScript to delete files <= "x" kb
Hello, I am looking for a script that will delete any file in a folder and it's sub-folders that are 100kb or smaller. Thanks in advance for any assistance with this script. -
VBScript to prompt a folder name
Hello, Does anyone have a VBScript that will go to a directory and prompt to rename a folder that already exists? Example: I have a folder named "Test1". After I do a file move and deletion, I want to get a prompt that identifies the "Test1" folder and asks for the folder to be renamed...
