KeriM

Member

Posts: 70

Quote:

Originally Posted by Spencer101

Hi,

Is there a reason this needs to be done with VBA?

There are formulas you could use to complete this calculation directly in the cell.

I'm trying to automate this process as much as possible. This is a bit of a pain to do manually. The workbook that I'm wanting to find all this information in cannot be written in. Can I do this in the workbook I want to copy the final result to?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Coult not find specified object" and "Path-File access error" messages	Robert Crandal	Excel Programming	3	December 19th 09 09:12 PM
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0,	Simon[_2_]	Excel Programming	2	August 11th 08 01:29 PM
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet	bjohnson	Excel Programming	1	September 20th 07 04:02 PM
HELP on "left","right","find","len","substitute" functions	serene83	Excel Discussion (Misc queries)	5	June 27th 06 02:23 AM

All times are GMT +1. The time now is 12:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us