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: 1
Default Pasting Variable cell info into a macro

I'm trying to use a macro to cut and past a date from a cell (which will have
various dates plugged into the cell) back into the macro directly. It works
great the first run as long as the cell information doesn't change. Then of
it doesn't self update the variable information from the cell on subsequent
runs. Being a newbee, how can I write this macro so it picks up the date
information from a specific cell so that when the macro is ran, it uses the
latest info in that cell each time? See below for what I've got so far which
won't update to new info from cell.


Range("B9:F9").Select
Selection.Copy
Sheets("BOM").Select
Selection.AutoFilter Field:=9, Criteria1:="=4/20/2010", Operator:=xlAnd
Selection.AutoFilter Field:=10, Criteria1:="THG"
Selection.AutoFilter Field:=3, Criteria1:="DWG"
Range("D4:D2200").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Routing Sht 1").Select
Range("A14").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets("BOM").Select
Application.CutCopyMode = False
Range("G4:G2200").Select
Selection.Copy
Sheets("Routing Sht 1").Select
Range("B14").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
 
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
Pasting a block of Word info into a single Excel cell PeterJordan Excel Discussion (Misc queries) 3 May 7th 07 07:24 PM
Copying and pasting table info and cell formating in one hit Sam at JWP Excel Discussion (Misc queries) 3 April 19th 07 03:24 AM
need help w/ macro prompting with info and pasting the info based on user input drgka55 Excel Programming 8 August 28th 06 06:05 PM
Info pasting into one cell?? Erin Excel Discussion (Misc queries) 2 July 26th 06 06:36 PM
pasting a range of info based on the value in a particular cell vsmith Excel Discussion (Misc queries) 0 February 10th 06 10:57 PM


All times are GMT +1. The time now is 07:45 AM.

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

About Us

"It's about Microsoft Excel"