Thread
:
Copy Contents from Cell
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Copy Contents from Cell
Instead of a cell you could use
myheader=inputbox("Enter this months header")
range("a1").value=myheader
or a simple formula using your cell idea
=sheet1!c1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Stonewall" wrote in message
...
Hi,
I am trying to create a macro to insert a header into my worksheets. I
would like to be able to enter what the header is to say in a cell and
create
a macro to copy those contents into the header portion to save me some
time.
The catch is that the titles that i need to type in will change from time
to
time, so the macro must be able to copy and paste dynamically. For
example
this month the sheet might say "Global Economic Outlook" but next quarter
it
might say, "Affects of Oil Demand". How can I get a macro to enter the
different data from the contents of a cell?
Thanks,
Dan
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett