Thread: Paste Special
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default Paste 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