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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Paste Special
Well I need the format to be exact on both spreadsheets because I will later use this to search for a match. I seem to be unable to get a match unless the format is identical. What is the best way to do this?- pbobel
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Paste Special
Hi, I need to copy the format of one cell on one workbook and paste the format to column F of another Workbook. I keep getting an object error. My code is below. Any help is greatly appreciated. Thanks, Sub Macro2() Dim RawFile Dim ArchFile RawFile =...- pbobel
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
-
using VLookup with VBA
Hi, I am trying to use the vlookup function to populate a certain column with data from another spreadsheet. I am prompting the user to specify both the data files ( one which contains information and the one to populate). I keep getting an" Out of Range error" on the follwoing line: Set rng =...- pbobel
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Vlookup with VBA
Hi, I am trying to use the vlookup function to populate a certain column with data from another spreadsheet. I am prompting the user to specify both the data files ( one which contains information and the one to populate). I keep getting an" Out of Range error" on the follwoing line: Set rng =...- pbobel
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
