| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have Excel VB Read from two sheets
ActiveCell.Offset(0, 238).Activate
Case "7CB" feecode = Worksheets("PPO-Custom").Range("B5").Value Case Else End Select -- Regards, Tom Ogilvy "cowannbell" wrote in message ... Okay ignore my prior note. I had to close the VB editior and it ran. However, it is still not correct, I've missed something. When it runs, it pulls up the sheet that is referenced and the cursor is in B5. It is suppose to stay on the same sheet and pull back a fee for that particular fee sch and fee code that was selected. -- cowannbell ------------------------------------------------------------------------ cowannbell's Profile: http://www.excelforum.com/member.php...o&userid=24522 View this thread: http://www.excelforum.com/showthread...hreadid=381184 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| min & average 52 work sheets all read zero | Excel Discussion (Misc queries) | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| In Excel is there a way to read the name of the sheets tab and di. | Excel Worksheet Functions | |||
| Excel sheets saved as XML files that can be read by .NET | Excel Programming | |||
Threaded Mode
