Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 64
Default input of selected cells equals content of another cell

Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default input of selected cells equals content of another cell

Try

Set rng = Selection
rng.Value = Range("N8").Value

Mike

"al" wrote:

Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help

  #3   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 64
Default input of selected cells equals content of another cell

On Jan 20, 4:23 pm, Mike H wrote:
Try

Set rng = Selection
rng.Value = Range("N8").Value

Mike

"al" wrote:
Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help


thxs
Reply
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
result given from content of selected cells. Rik_A Excel Worksheet Functions 5 April 29th 10 04:04 PM
Excel cell value equals selected text from Word sarahphonics Excel Discussion (Misc queries) 0 April 19th 10 04:15 PM
cell automatically deletes content if cell is selected LD Excel Discussion (Misc queries) 0 November 1st 07 04:45 PM
Deleting Cells where content equals "0" or null bm4466[_6_] Excel Programming 0 August 3rd 06 07:16 PM
Selected Cell equals x then.. CCManager Excel Programming 3 July 28th 04 09:22 PM


All times are GMT +1. The time now is 03:40 AM.

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"