pasting of variable cell value into macro
I have written a macro that runs an autofilter which grabs cell info from a
different worksheet within that workbook (an entered date). It then uses that
date to autofilter. It works fine the first time, but aparently plugs that
info permanently into the macro and will not work on subsequent runs. I need
a macro that will grab variable info from a certain cell each time and run
with that new cell value each time. Any ideas?. (& yes, I am a newbee)
Your problem is refreshing the autofilter. It is best to clear the old
filter before applying the new filter. Here ...Internationalization for formulas & macros
I have a relative who send me some Excel spreadsheet (97, 2000 or XP
that contains formulas and macros written in english.
However, I have a french version of Excel. Because of this, I can'
open these spreadsheets.
My question is quite simple.
Is there a tool or an easy way to convert all formulas & macros withi
a spreadsheet from english to french?
Any help will be appreciated.
mictou's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1637
View this th...able to record & run macro but not edit !
When I open a file with an existing macro (or create a new spreadshee
and simply record an entry in a cell ) and go to Tools/Macro/Macros th
macro list is visible and I can run the macro but if I try to edit it
get a Microsoft Visual Basic pop-up 'Unexpected error ; quitting' o
if I simply try to open the VBE i get a similar pop-up with ' Out o
Same files work fine at work (Excel 97) where I edited macros n
I've tried uninstalling/reinstalling Excel from the office 97 dis
along with data access & Office tools (and their elements) ti...Macro
Thanks to those who offered help but I still am not quite there with the
R.Venkataraman's code was almost correct but I don't think I explained
In my sheet1 the user inputs numbers (1-50) in column A.(pluss loads of
other data in columns B:P) what I require is the macro to ask the user to
input the 'job' they want to print. So if the user inputs <9> then column A
in sheet 1 is searched for the number 9 then the contents of that particular
row are copied (without formula - just cell values) and the data pasted onto
row A2 of sheet...Hide worksheets if macros are disable
Hi, what I was hoping to do is if the marcros are disable when the file
is opened all the worksheets are hidden except one with a message
saying to enable macros in which case this sheet would be hidden if the
macros were enable. TIA
If macros are disabled, there's nothing you can do to change they way it opens.
Maybe you can save the file with the worksheets hidden the way you want. Then
have your auto_open/workbook_open unhide the ones you want to see.
> Hi, what I was hoping to do is if the marcros are disable when the file
> is opened all the work...Excel should allow macro on a shared workbook.
We are using excel tables all the time at my company. There are more than 20
people working on the same excel file which has thousands of columns so we
use autofilter or some other macros.
Shared workbook will help us alot because we will be able to change the file
at the same time which is very time saving.
Is there any way that macros are allowed at shared workbooks?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not ...About Macros #2
Even though I have deleted all macros from my workbook, I
still get the pop-up saying that macros are disabled. How
do I get rid of this annoying feature?
Thanks for all help,
Debra Dalgleish has a great explanation with pictures on how to deal
with this issue.
Be advised to back up your WorkBook before attempting to make changes.
------------------------------------------------------------------------------...VBA Question: Called macro stops unexpectedly
I'm new to using VBA in Excel. I'm hoping I'm missing something
simple and that someone here can help me.
I have one Excel workbook that has many subroutines/macros in Module
1. I have 5 worksheets in the workbook and each has navigation
buttons to move from sheet to sheet. On one sheet, there are required
fields that must be checked before a user can be moved to the desired
sheet. The buttons call the appropriate macro, like GoTo_Report,
which takes the user to the Report sheet. But, on the Project Info
screen, I need all these buttons to also run the macro that chec...Macro to find the first cell in a column with different data
I really could use some of your expert and excellent help with a problem I
am having in creating a macro to perform a search in "Column A" to locate a
change in the data in that column and then move one column to the right and
one row down and type "1" in that cell.
I really appreciate your help, and Have a Blessed Holiday Season.
Perhaps this might also do it here ..
Assuming data is in A1 down, of the structure as below:
Put in B2: =IF(A2<>A1,1,"")
Kill the formulas in col B with an in-place:
Copy > Paste spe...can't record a new macro or insert module in editor
When i try to record a new macro it tells me it is unalbe
to record. When i go into the VB editor and go to the
insert menu all the items are greyed out so I can't
select module and so create a new macor that way. I have
changed the security off from high (tried on both medium
and low). Does anybody know why I can't make new macros?
Unfortunately the "Unable to record" message has several potential causes.
Suggest you wander through these google search results dealing with this
issue. Perhaps something will do the trick.
The Personal.xls file ...Filtering data within macros
I have a spread sheet with 6 coloums of data such as name,month,job.
have filters so i can see how many jobs are done in a month or how man
jobs one person is doing. I would like to be able to write a macr
which works out most of the combinations of filters and outputs it t
a seperate sheet. There are lots of different options for each coloum
tho! Is there any quick ways i can do this other than reseting th
filters everytime for every combination?
hope i have explained this ok....its even confusing me!!
Message posted from http://www.ExcelForum.com
This may be helpful
...macro to delete multiple rows
I have recorded, then modified, the following macro, which unprotects the
sheet, aks if you are sure you want to delete the row, deletes the current
row, copies down a cell in column A that numbers the row, and protects the
sheet. Works fine, but if the user wants to delete not only the current row,
but multiple rows below it also, the macro must be repeated. How can I
accomplish deleting multiple rows, as indicated by the user? For example,
rows 18 thru 20, or 29 thru 33, etc, or of course, just the current row,
with the message box prompting the user for the number of rows to delete.
I need to know how to 'default' the save file type as an .xls from a .dat
within a macro. After a macro has completed changing many .dat files into
excel spreadsheets to include subtotals, the file type is defaulted to .dat
and when I go to save the file, I have to constantly change the file type
from .dat to .xls.
> I need to know how to 'default' the save file type as an .xls from a .dat
> within a macro. After a macro has completed changing many .dat files into
> excel spreadsheets to include subtotals, the file type is defaulted to...How do I run a macro when a value occurs in a cell
I want to run a macro when a value appears in a cell.
How can this be accomplished?
This is a trivial example but you can build on it:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("D3") = 36 Then
Range("D3").Interior.ColorIndex = 6
Range("D3").Interior.ColorIndex = 2
Put =A3*3 in D3
Try values such as 12, 10 in A3
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http://www.excelforu...Using a macro question.
Can you execute a macro from inside a formula? IF(A1="Y",execute.macro,"")
Adam, not with a formula, but you can use a worksheet change event like
this, put in sheet code
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$A$1" And UCase(Target.Value) = "Y" Then
'put your code here
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Usin...Hyperlink to open .dot with a macro
I have a word .dot that has a simple macro when opened, but when I try to
open the .dot from a hyperlink the macro doesn't autostart. Any ideas?
I opened word and created a new test2.dot template file.
I put this code under the ThisDocument module:
Private Sub Document_New()
MsgBox "hi from new"
Private Sub Document_Open()
MsgBox "hi from open"
I put a hyperlink in a cell in an excel worksheet that pointed to that test2.dot
The Document_Open() event fired--but the actual template (test2.dot) opened--a
new document bas...Can I create a report from this without a macro?
(XL2007) My data is presented in 5-row groups. Cols A, B, and C have
my identifiers; col AU has a text value I need to include. Headers in
row 9; cells in cols A, B and C are merged in groups of five (A10:A14
merged, A15:19 merged, etc, and same for B and C); in the Name Box,
though, data in the A10:A14 merged group shows up as A10. Col A is
the major group, col B is the sub-group, and col C is the ID number of
What I would like is something like a pivot table. I tried that,
though, and XL told me I didn't have a valid range, or valid headers,
or something like that. ...Help: Macro that runs various if statements, inserting rows etc
I am a newcomer to Macros and excel programming and was hoping someone
could assist / provide the code to do the following:
I have a +50,000 line spreadsheet, that needs to be formatted. Given
the size I would like to automate this. There are 3 key formatting
changes required and detailed below:
n = 1
1. If Cell A(n) not equal Cell A(n+1) then
insert a new row below A(n), make Cell F(insertedrow)=1, make
Cell G(insertedrow)=A(n+1), make Cell H(insertedrow)=B(n+1)
2. If Cell C(n) not equal Cell C(n+1) then
insert a new row below C(n), make Cell F(insertedrow)=2, make
Cell G(inserte...Help With Macro Modification
I have this macro which will copy a group of non-contiguous cells to
another sheet. What I would like to know, is it possible to also make it
when it paste to new sheet, paste it as a "paste link". I need to be able to
change info on original sheet, but udate cells on other sheets as a paste
Dim SelAreas() As Range
Dim PasteRange As Range
Dim UpperLeft As Range
Dim NumAreas As Integer, i As Integer
Dim TopRow As Long, LeftCol As Integer
Dim RowOffset As Long, ColOffset As Integer
Dim NonEm...Excel Macro Vista not working
I have a trial excel 2007 version that came with my Vista Home
I had a spreadsheet which contains macros and I had no problems
running with XP.
I changed some of the settings and completed the following:
I followed the following link from the developer of my particular
spreadsheet and completed the following for 2007 version:
I still cannot use some of the functions that I had been using before
such as Sort and doub...Macros actioned by drop down list
I have a drop down list in cell C1 list being validated from a list o
53 cells: A1:A53 (cell A1 being "week1" , cell A2 being "Week 2" etc)
I will record 53 macros (Macro "week1", etc).
1- Is it possible to assing the macro "Week 1" to cell A1 ?
(It is not a basic shape. Just a value in the cell.)
2- After assigning each macro to each cell, is it possible to start th
macros in Cell C1 by choosing from drop down list.?
( Example. in cell C1 I select "week25" and by doing this macr
Message posted from ...Unprotecting multiple worksheets w/ Macro
I am protecting with a macro, multiple worksheets in a workbook with a
macro. I can't get the unprotect of multiple worksheets to work.
Does anyone have a working macro to do this.
Dim sh as Worksheets
for each sh in ThisWorkbook.Worksheets
if sh.ProtectContents or sh.ProtectScenarios or _
<firstname.lastname@example.org> wrote in message
> I am protecting with a macro,...How do I maintain macros on a Custom Toolbar
I converted Access databases from 2003 to 2007 format. The Custom Toolbar
from 2003 came with to 2007. How do I add or delete from the custom toolbars.
I want to add the macros for additional reports and queries on the current
On Fri, 9 Apr 2010 06:25:01 -0700, Ann <Ann@discussions.microsoft.com>
You should probably take the time to convert them to the new Ribbon
interface. When you get over the learning curve it really is a
There are tools available like this one: www.ribboncreator.de/en/ if
you don't want to write the xml code ...Macro maximum range lengths
I am trying to enter code to auto-expand merged cells. I have multiple ranges
within the same worksheet that will be affected by this macro. I believe that
I have reached the maximum range length for the macro. I need to add more
cells. How would I go about adding them to this macro OR can I add a second
macro for the additional cells?
Here is what I currently have:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim r As Range, c As Range, cc As Range
Dim ma As Range
Set r =
Range("A18:G18,A19:G19,A2...CAlling Excel MAcro with arguments
I want to know if it's possible to call a macro with arguments from a dde
I am able to call a macro without any arguments with the following DDE
char cmd = "[RUN(\"showme\")]";
DDEExecute( idInst,hConv1, cmd);