 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / July 2008Paste Special
I have created a lattitude/longitude spreadsheet, wherein I search the lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar A simple macro will do the trick Sub Macro2() Range("b4") = Range("h2").Value Range("b5") = Range("i2").Value End Sub If you don't know anything about macros - do a google search for "Excel macros"  SignatureWag more, bark less > I have created a lattitude/longitude spreadsheet, wherein I search the > lattitudes and longitudes of various cities in order to compute the distance [quoted text clipped - 16 lines] > > FLKulchar Thanks..but, too bad, I know nothing about macros...it is about time I learned, but I find all the "help" centers not to my liking; perhaps I need to take a class in MACROS! Thanks, FLKulchar >A simple macro will do the trick > [quoted text clipped - 30 lines] >> >> FLKulchar Can I record this macro by typing exactly what you wrote? Do I need to select one of my cells to do so? >A simple macro will do the trick > [quoted text clipped - 30 lines] >> >> FLKulchar Why are you copying H2 and I2 and pasting to B2 and B5? In B2 enter =H2 In B5 enter =I2 As H2 and I2 change so shall B2 and B5 Gord Dibben MS Excel MVP >Can I record this macro by typing exactly what you wrote? > [quoted text clipped - 33 lines] >>> >>> FLKulchar |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.