Setting A1 To Equal Workbook Name

Jul 13, 2009

I need to put the workbook name in cell A1, although if the workbook is FOOTWEAR - 572.xls, I need cell A1 to say Footwear_572.

View 9 Replies


ADVERTISEMENT

Setting A Cell Equal To The Selected Value In A Combobox

Mar 26, 2007

I know you can set cells equal to other cells, but can you set the cell equal to a combobox created in VBA.

View 2 Replies View Related

Setting Up Menu In Workbook?

Dec 13, 2012

I have an excel workbook with multiple worksheets(tabbed across the bottom of the workbook). How can I set up a menu of the worksheets on the left hand side of the workbook that enables me to jump to that worksheet?

View 4 Replies View Related

Setting Protection On Workbook To Be Read Only

Dec 7, 2012

I have a Workbook named "Master Archive" that contain data from 9 workbooks. This is all done with a macro upon opening each workbook and using a command button to send the data to it. Question is I want everyone to be able to view the Master Archive Workbook in a readonly fashion and the orginal to always remain closed. Reason being is I cant run the macro to archive the data if someone has it open, which then would cause debug issues with the code.

Are there settings were I can be the only one to open the workbook and be able to Edit.

Also Everyone has a shortcut to this Master Archive on there Desktop.

View 8 Replies View Related

VBA Replace Method Retains 'Within Workbook' Setting

Nov 8, 2008

I am selecting a block of cells to apply numerous "Replace" functions to.
So I use the Selection.Replace command - for example:

Selection.Replace What:="Street", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

if I have been working with Excel previously and did my own "Replace" and applied it to the entire Workbook (i.e. changed the within field from ' Sheet' to:
"Within: Workbook"

Then that field stays set to "Workbook" for subsequent Replace activities, including my VBA code !! Therefore if I do not manually go back and run one "Replace" and set the within field back to "Sheet", the VBA code will apply my Replacements to every sehhet and every cell in the entire workbook. Even if I have selected a Range of cells before issuing the command !! It ignores the selected Range and runs the "Selection.Replace" for the entire Workbook.

The "fix" I found on another site is to run a dummy command:

Set dummy = Worksheets(1).Range("A1:A1"). Find("Dummy", LookIn:=xlValues)

Which works. However, I am looking for a way to add a parameter to the "Selection.Replace" command that will cause it to search using the "Within: Sheet" setting. Otherwise I always have to remember to add that dummy line of code for every single Selection.Replace line of code.

View 9 Replies View Related

Subscript Out Of Range - Error Relating To Setting Workbook

Jul 11, 2014

I'm trying to do the following

Dim wkb As Workbook
Dim wkb2 As Workbook

Set wkb = ActiveWorkbook
Set wkb2 = Workbooks("F:SuppliersBT Monthly Invoice2014BT Macros.xlsm")

but get a subscript out of range error relating to setting wkb2

The file BT Macros is open - this is where the Macro is stored. What have I done wrong when trying to reference it?

View 5 Replies View Related

Excel 2002 :: Setting Variable To Select All Worksheets In Workbook

Jan 20, 2012

I've got some code which some one posted me a link to on here which set up a pivot table on more that 1 sheets (using excel 2002).

I inserted this code into a rountine I do daily which works fine.

The problem Im having is that Im getting more and more info which I need to pivot over more than one sheet. So I was going to amend the rountine so It picked what ever sheets are in the work book to pivot.

At the moment I have to go into the code and name the sheets to pivot. Is there some code which can work out how many sheets that need pivoting and just do it with out naming them? and also just add a new sheet with the pivot on rather than having to name the destination?

I've posted the code i got given below and have highlighted the bit where I have to name the sheets.

Code:
'---------------------------------------------------------------------------------------
' Procedure : CreateConnection
' Author : KL (Kirill Lapin)
' Date : 18/08/2009

[Code]....

View 8 Replies View Related

Can I Change A Setting Somewhere To Make Close Its Default Blank Workbook When I Open An Existing One

Feb 9, 2007

I have Excel 2002. If I start the program it opens with a blank workbook, called "Book 1".

If I then open an existing workbook, I have two Excel buttons in the Windows taskbar: the one I just opened, and the blank one titled Book 1.

At work I have Excel 2003. The blank "Book 1" is also there when I start the program, but if I then open an existing workbook, the Book 1 goes away. I like this way better.

My question is: Is this just the way versions 2002 vs. 2003 work, or can I change a setting somewhere to make Excel 2002 close its default blank workbook when I open an existing one?

View 9 Replies View Related

Values Which Are Equal Not Treated Equal

Jul 5, 2007

I'm having trouble with a small vba macro. At the end of the macro I test to see if two variables are equal and then print out true or false. However, for some reason even though the variables are equal vba is not treating them that way. I have put the values that represent the variables on a spreadsheet and used the if(x1=x2) formula and it says it is true, also, when I debug the macro and watch the values when it comes to test the logical expression the numbers are the same. I don't understand why vba does not say that the two variables are equal. I have attached a screenshot of the breakpoint where I double check the values are equal.

View 2 Replies View Related

Count If A Cell Is Equal To Cell In Different Spreadsheet And Is Less Or Equal Zero

Apr 17, 2014

How to correct my formula because it does not work?

Here the formula: =COUNTIFS(Data!C2:C24005,A17,Data!M2:M11149,"<=0")

I need to insert the formula in column C (Findings tab) which counts the rows in Column M (tab named "Data") that equal A17 (Column A in "Findings" tab) and which are less or equal zero. In addition if I drag the formula down I want to only the values be entered in highlighted in blue cells in column C (SKUs With Zero Sales in "Findings" tab) and empty cells in not highlighted cells. I attached images of these two tabs: Data and Findings.

View 5 Replies View Related

Countif- Where Column A Is Equal To A Specific Number And Column B Is Equal To Another Number

Jun 29, 2008

I'm trying to count if there are situations where column a is equal to a specific number and column b is equal to another number.

both columns are numbers. Does anybody have a good idea how to do this, maybe countif, but i am not sure how to do more than one item with that.

View 9 Replies View Related

Setting The Conditions?

Mar 13, 2009

What formula could I use to return the following results.

1, 2, 3,4, 5, 6 = Manhattan
7 through 12 = Bronx
31 = Staten Island

View 2 Replies View Related

Setting Up Input Box

Jun 21, 2009

What I want to be able to do is set up a thing that when you're in the excel sheet you click on it. Up comes a box where you can enter data and when you click submit. It puts that data back into excel spreadsheet. I have attached a spreadsheet to show what I mean. I have deleted some stuff that are unnecessary so don't worry about them.

What I need is for you to click a button that will create a new row/copy into the next row, from A9-AH9. Then the button will automatically bring up a box that will ask for Time, Timber, Clay, Iron, Warehouse, Hiding Place and then will enter that data into there respective cells which would be D20, F20, I20, L20, O20, Q20 respectively. That is the main idea. maybe it would be better to have te button come up with a box asking for the information and then will create the row and insert the data. If it's easier you can just do the box with just time or something so it's easier. I can then do the rest.

Tyvm. This to me seems really complicated so not sure how you would do this at all. i've looked at other stuff on the internet but haven't gotten anywhere.

P.S. If you have a more generic thing similar to this then show me the code for that or upload it and I can change it too suite my needs.

View 14 Replies View Related

Setting AutoFilter Via VBA

Jan 20, 2010

This macro was working just fine, now it generates an error on the line in red.

View 2 Replies View Related

Setting Up A Log Equation

Oct 9, 2009

It looks like this (log(X/Y))/log2. The X and Y are celldirections (E2 or F4 and so on). How do i setup that formula in excell?

View 2 Replies View Related

Setting Conditions

Jan 1, 2009

I have the word "Gross" in a cell at the end of each month on one sheet. I need to calculate totals for each month above this columns so lets show it as this:
A B
1 100
2 150
3 220
4 300

Gross 770

How can I set up a macro to always calculate what my gross is setting a condition to find "Gross" and then somehow select the cells above it up to A1? I will have another cell as "Gross" for February under the rows of information for January. I am not at all sure if this can be done.

View 9 Replies View Related

Setting Up A New Database

Oct 13, 2009

I am trying to set up a database to collect information on students behavior. We need to collect the frequency of 3 things-time of day, behavior, and correction. Can I do this in Excel? How? Is there a way to write a correlation that will count the occurrence of words?

View 9 Replies View Related

Setting Range

Mar 15, 2007

How do you set the range with whats below? Right now its looking at 4,2 only and if extend to look all the way to 19,2 it will just copy the whole screen. I need it to look at 4,2 and then move to 5,2 and then so on once it has copied all that information to the sheet ...

View 7 Replies View Related

Setting Up Mailing Labels

Dec 8, 2009

I just received a massive worksheet full of information for mailing labels. It's all in columns-which is excel. Is there an easy way to set this up for mailing labels? I've tried to import it into word, but I'm not getting anywhere. Is it possible to change the way excel displays the cells? To a point where I can have the address beneath, then the state, zip, etc?

View 9 Replies View Related

Setting Text To Date?

Sep 16, 2013

I have a problem with an file that I have exported from another software program (I believe in CSV). The file seems to be in tekst format but I can not change it to date format. I need to know which weekday is which date. So january 1st is a tuesday and so on..

View 4 Replies View Related

Setting Up Spreadsheet That Will Transfer Value To Another One

Mar 11, 2014

I am setting up a few spreadsheets for a restaurant I work at and I am stuck on an excel matter. I am trying to have an ordered number transfer to a new spreadsheet that will apply that ordered amount to a monetary value. So all my cooks would do is put the prep list on dropbox and it would take the ordered amount by the recipe cost to get an invoice for that day.

Example:
1st Sheet 2nd Sheet 3rd Sheet
Prep List: Recipe Costings: Daily Invoice:
Sausage - 2 x Batch Sausage - $229.03 $458.06
Pesto - 3 x Batch Pesto - $74.04 $222.12

View 3 Replies View Related

Setting Range For Sheet3?

Jul 2, 2014

How can i set the range for the Sheet3 i have taken IngDataColumn. It select only particular column of fixed that is 4

[Code] ....

View 14 Replies View Related

Setting Print Area By VBA?

Aug 19, 2014

I have looked for a way to set the print area of a worksheet through vb.

I would like it to find the last row of the worksheet and set it to be printed.

Some of the examples take it beyond the last row of data, because the the code that may be in the empty cells.

HTML Code: [URL] .....

View 2 Replies View Related

Setting A Global Variable

May 27, 2008

If I want to set a global variable when I open my workbook which will be used in code on the individual spreadsheets, how would I do this? I want to set the time the workbook is opened to a variable (constant) and then compare that time to current time on each calculation in the worksheets.

I'm using Excel 2000.

View 10 Replies View Related

Setting Worksheet As ActiveSheet

Oct 22, 2008

I have a WorkBook with each sheet being a calendar month. I want to set the ActiveSheet as the current month so each time I open the WorkBook it opens to the current month WorkSheet not the last WorkSheet I was viewing.

View 12 Replies View Related

Setting Page Breaks

Dec 2, 2008

how to write code to set page breaks every 4th column, or in certain intervals. For rows I have a simple .FitToPagesTall = 1, but I'm looking for something more dynamic for the columns.

View 4 Replies View Related

Setting Background Colour

Dec 4, 2008

I am wanting to create a function, callable from a worksheet, that sets the background colour for any given range of cells to a given RGB value. I am confused about the Color and ColorIndex properties. I'd have thought the following piece of code was trivial and would work but it doesn't.

View 4 Replies View Related

Setting Focus On Userform

Jul 7, 2009

I have a userform that is called by clicking on a button and it copies the value in cell A to my userform. This works great it is called via:

View 5 Replies View Related

Focus Not Setting Correctly

Jul 21, 2009

I have a userform with several inputs which are validated, and should the input be invalid an ErrorProcedure is run. This basically displays a message telling the user what is wrong, and it should also be highlighting the text in the relevant field, but for some reason it is not doing that.

View 6 Replies View Related

Setting TabStop Within UserForm

Sep 14, 2009

I have a userForm and I use a load, set the field defaults and show sequence to use the form. I want to be able to set the initial field (a "setFocus" didn't work) and then how pressing the tab will move through the fields.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved