LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Using formula in a macro?

I am able to use the macro recorder to navigate and execute simple things. I
need to be able to use formula (specifically VLOOKUP) in my macro, and don't
know how to do it. Made a post earlier, but perhaps it was too vague as I
have yet to see any ideas. (Jan 20 Need to paste/update info to correct row.)

1. I have a row of information that begins with a number.
2. I need a macro to find the same number in the beginning of a list of
numbers all in the same column, and then select that cell.

I can then copy/paste the new information over the old in the correct row.
Hope that makes more sense.

Lonpuz
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula - Macro orquidea Excel Discussion (Misc queries) 7 December 7th 07 02:19 AM
Macro with formula orquidea Excel Worksheet Functions 3 December 5th 07 08:53 PM
Formula in macro causes macro to fail KCK Excel Programming 2 February 8th 07 08:47 PM
Help with macro or formula JAZZNAURA Excel Discussion (Misc queries) 0 August 18th 06 08:41 AM
Formula expected end of statement error, typing formula into cell as part of VBA macro [email protected] Excel Programming 1 July 20th 06 07:58 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"