Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Magenta Ricci   on Nov 02 In MS Office Category.

  
Question Answered By: Sammy Brown   on Nov 02

Sub Changevalues()
Windows("Master.xls").Activate
Range("AV18").Value = False
Range("AV19").Value = True
Range("AV22").Value = Range("AW22").Value
Range("I28").Value = Range("AB28").Value
Range("I30").Value = Range("AB30").Value
Range("I32:I36").Value = Range("AB32:AB36").Value
Range("I39:N39").Value = Range("AB39:AG39").Value
Range("I41:N41").Value = Range("AB41:AG41").Value
Range("I43:N43").Value = Range("AB43:AG43").Value
end sub

I think all of my macros  begin with the line Windows
("Master.xls").Activate . Unfortunately as i say its actually going
to have to run  under any name instead of master. I'm trying to work
out the easiest way to do it. Because its for other people whoare
not very pc friendly i'm trying to make it a simple click this
button process. However the buttons and macros are in a seperate
workbook from the master.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on macro to get info from workbook thats name changes Or get search suggestion and latest updates.


Tagged: