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: 55
Default How do I update without sheet select

Hello
I have the following code; I would like to do the same thing without
sheet and range select.

Sheet1.select
Range("B3").select
Activecell(1,1) = "xyz"
Activecell(1,3) = "month"
Activecell(3,2)= "Sales"
....
etc
Many thks, Rgds Kz

 
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
Possible to handle database insert, update and select in excel? anders123 Excel Worksheet Functions 0 May 23rd 08 03:20 PM
when i select dont update I get #REF! mmollat Excel Discussion (Misc queries) 4 March 14th 07 09:36 PM
How do I select price from sheet.b where sheet.a part no = sheet.b Sonny Excel Worksheet Functions 4 April 4th 06 05:08 PM
select workbook to update milkshake Excel Programming 2 February 27th 06 04:52 AM
Select Sheet then Select Range Gee[_2_] Excel Programming 3 May 27th 04 10:10 PM


All times are GMT +1. The time now is 04:00 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"