Posted to microsoft.public.excel.programming

kaon[_4_]

external usenet poster

Posts: 1

Query replace by VBA

Hi all,

I have 5x cells with the formula like
VLOOKUP(B3,PNOA!A:Z, 4, FALSE) / 1000

How can I do query replace the 4 by other value, say 10, for cell
having the similar formula? To be precise, I wonder how can I replac
the 4 without using functions like left(), right()?

Thanks in advance

--
Message posted from http://www.ExcelForum.com

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
Find/Replace External Data Web Query	Gary Spranger	Excel Worksheet Functions	3	July 4th 07 06:40 PM
Replace ^ in web query result	Don Guillett	Excel Worksheet Functions	0	April 26th 06 03:42 PM
How to Delete a Range in Closed Workbook (to Replace Delete Query)	[email protected]	Excel Discussion (Misc queries)	1	March 8th 06 10:10 AM
Replace with result of database query, instead of inserting	Android[_2_]	Excel Programming	2	May 12th 04 04:38 PM
Replace ActiveCell w/Query Results?	pkillebrew	Excel Programming	1	November 5th 03 11:03 PM

All times are GMT +1. The time now is 05:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us