0
votes
1answer
74 views

VBA Lookup by Multiple Criteria - Then Copy & Paste

Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase. I would like to lookup rows of data by multiple ...
-1
votes
1answer
36 views

Format of Row in VBA based on 1stCell and also Compare to above row?

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current ...
0
votes
1answer
374 views

Excel - compare names in two cells in different order

I need to compare the following Cell 1 John Peter henderson Cell 2 peter John Henderson Result Match Cell 1 Anne jolie ...
2
votes
2answers
622 views

Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...
0
votes
2answers
142 views

Incorporate VBA and Copy and Paste

I wonder whether someone may be able to help me please. I'm using the code below to autopopulate a number of columns with pre-defined text when a value is entered into column "B". Option Explicit ...
1
vote
0answers
809 views

How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this? The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...
0
votes
2answers
385 views

How can I speed up my macro in Excel 2003?

I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows. When I run it in Excel 2003, Excel starts to slow ...
0
votes
2answers
2k views

Get all linked files to an Excel 2003 document

I want to get a list of all the linked files in an Excel 2003 document, or, better still, automatically retrieve all the files linked to the document and zip them. Is such an operation possible? I am ...
1
vote
1answer
744 views

Can the Selected Excel Custom View be determined

I know I can show a custom view in excel with vba. What I need to do is determine which custom view was selected by a user, to alter a column header based upon that selection. They are using this to ...
0
votes
1answer
526 views

VBA xlColumnDataType in Excel 2003

When importing a txt file into excel, I need to specify data types for the columns. I'm currently using Excel 2003 (upgrade to 2010 is for later in the summer). I have been able to find enumerations ...
0
votes
1answer
1k views

In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all

I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output. There are ...
1
vote
2answers
2k views

Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...
2
votes
3answers
3k views

How to add URL in a cell comment using VBA?

I am using Microsoft Excel 2003 wherein i have a cell which has a comment. The comment has text as well as URL. Is it possible to create a hyperlink (URL) in comment box where user can click and it ...