Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Adjust Cell Height To Fit Text


way to get Excel to automatically expand the cell height when the text becomes to long to display. Is there something I am missing that will accomplish this, or do I need to write some VBA that will make the cell larger once the character limit that will fit on one row is exceeded?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Fix Textbox Width And Automatically Adjust Height To Text
how to automatically set a text box size to display text contained by right-clicking the textbox and put a check in the auto-size box under "Alignment".

However I would like to set the widht of the text box and automatically adjust the height according to the number of lines of text. Is this possible by VBA code or othe means?

View Replies!   View Related
Automatically Adjust Row Height
I have a vlookup into a row of cells. Sometimes the new text is so long it has to word wrap. How can I get the ros to expand with out me manually doing each row, and then go back to one line with the data changes.

View Replies!   View Related
Adjust Userform Height Via SpinButton Linked To TextBox
I have a userform with a listbox set to a range of numbers from 1-10, I would like my userform to expand/collapse dependant on the number within the listbox. The problem I am having is the forms height does not adjust from using the toggle controls only when you select back into the listbox itself.

Private Sub ListBox1_Change()
If Me.ListBox1.Value = 1 Then
Me.Height = 180
End If
If Me.ListBox1.Value = 2 Then
Me.Height = 210
End If
If Me.ListBox1.Value = 3 Then
Me.Height = 240
End If
End Sub

I have tried using click/after change events however I get the same response. Am I missing something from my code or should I be using another control (SpinButton for instance).

View Replies!   View Related
Finding The Column With The MAX Height In Comparson Wth Othr Columns Of UNEVEN Height
Finding the Column with the MAX Height in comparison with other Columns of UNEVEN Height

I need two things :

1. I have several columns starting from Column B till Column F, each column having values starting from the third ROW.

Ex:-

Lets say Column B contains two values in B3 and B4, Col C three values in C3 C4 and C5, Col D four values D3,D4,D5 and D6, Col E two values in E3 and E4, Column F five values F3,F4,F5,F6 and F7.

So, the answer is F3:F7.

2.I am using 10^{4,3,2,1,0} in a particular portion of a formula, Now the number of elements in the array or in the Curly Braces depends on the number of Columns filled from Column B as explained in the Point 1.

Now, since I have five columns under consideration I have this order as mentioned here {4,3,2,1,0} , I would like to know whether I could make this dynamic, as in if there were only four columns then this would be {3,2,1,0} and if more this array could self-fill and expand..

If that's possible, then how do we use it in the formula, Is it by the virtue of the INDIRECT function?

View Replies!   View Related
Formula For -- If Text = 1 And Text =-1 Adjust Running Total
formula for -- If Text = 1 and Text =-1 adjust running total
example:

1312 (total)

SS1311 (new total)
LA1310 (new total)
LB1309 (new total)
LS1310 (new total)

LS =+1
SS, LA, LB =-1

View Replies!   View Related
Display The Row Height In A Cell
Can I display the row height in a cell

View Replies!   View Related
AutoFit Row Height On A Merged Cell
I'm using Office 2007 professional and I'm trying to format a cell (merged cell) so that when you enter text and it goes beyond the size of the designed cell that it will automatically continue and shift the additional text downward, like a paragraph. Also it shift everything below down with it. Is this possible? I have already tried wrap text field and AutoFit row height. This keeps it within the cell but it is not visible or printable once you tab out. I would like to have it continue like in a paragraph. Like a word doc may do. It’s visible and it shifts everything below downward as it grows, which also allows it to be printable.

View Replies!   View Related
Using A Value To Adjust A Cell Reference
I have a spreadsheet set up for my son to roll up D&D characters. There's a combo box to select Race and another for Class of character. What I now need to do is automatically insert the correct set of racial and class bonuses into the relevant squares.

The Combo box points to a list of Races on Sheet 0, in cells A3 to A12. The cell reference for this returns a value between 1 and 10 depending on race selected, i.e. 'Dragonborn' yields a 1, and 'Tiefling' yields a 10. Cells H3 to H12 contain the Strength modifier for the different races.

When I select for example a Dragonborn (1) in the combo box, I want the Strength Modifier cell to pick up the value from cell H3, and if i change the selection to Tiefling (10) I want the strength modifier cell to pick up from (obviously) cell H12

How do I use a variable in the cell reference to adjust the cell data is retrieved from?

View Replies!   View Related
Copy/Paste Not Copying Cell Formatting (row Height)
I am having a problem with a excel spreadsheet. There are no formulas or anything, just text that I used excel to get everything lined up. I haven't had any issues before, I was copying and pasting within a document. It was all text with different row heights set. I ran into a problem now where the text copies and pastes fine but the row heights aren't coping into the cells I am pasting into, just the text. What do I have to do so they will copy? I don't want to have to go an individually adjust each cell.

View Replies!   View Related
Adjust Macro Tocompare To Cell Above
I have been the code below in many a different form since royUK first helped me find a certain value and delete the entire row. I've used it to find values, text, multiple conditions and so on and so forth, but I cannot figure out how to compare the cell to the cell directly above.

View Replies!   View Related
Formula To Adjust Based On Target Cell
I have a spreadsheet at work . I am tracking the quality target for the department and I need to create a formula that adjust accordingly to the target set for month end which is 90%.

I have build in the foreacasted numbers for the whole month but I need the formula to indicate the minimum error points needed to achieve the target of 90% for month end when I replace the forecasted numbers on a daily basis with actual numbers.

I have attached the spreadsheet which will be clearer.

View Replies!   View Related
Row Height
I am using excel 2003. I have copied and pasted text from microsoft word onto excel.

The text is already split up into rows and columns in word. When i past it into excel and select all thousand or so rows and then double click the row to engage the automatic row height it doesnt work. It cuts off the last line or last two lines of the text in most but not all of the cells. What can I do other than one by one change the row height?

View Replies!   View Related
Autosize Row Height
I have a spreadsheet in which double clicking on any of the cells in the range A4:C17 changes the contents of cells F4:I33. The following code tells me which is the active cell and then pulls the values for F4:I33 from a lookup table based in this.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Range("B100") = ActiveCell.Address()
Cancel = True
End Sub

code to stick in this (probably after the third line) that autosizes rows 4 to 33. There are no merged cells involved.

View Replies!   View Related
VBA Can Keep Track Of Total Row Height?
I was wondering if VBA or Excel has the capability to add and total Row Height or Pixels? For example I have my Rows set to a height of 14.25 (19 pixels). My Range that I am working with is A2:T41 for a TOTAL ACCUMULATED ROW HEIGHT of 570 (40 Rows X 14.25) and 760 Pixels (40 X 19).

What I would like to accomplish is that once the TOTAL ACCUMULATED ROW HEIGHT of my Range reaches 570 then Row 1 appears. If the TOTAL is less then 570 then Row 1 remains Hidden.

Does anyone know IF and HOW this can be done? I need this due to the fact that the Rows will Autosize and I need to have my header Row appear. I can't just Freeze Row 1 because my actual Headers are on Row 16.

Hope this makes sense and hope that someone has a solution.

Bye 4 Now,
Mar

View Replies!   View Related
Set Height And Width Of Cells
I am in desperate need of a macros that sets the heights and widths of columns and rows on a list of provided spreadsheets.

On each of these sheets:

MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", _
"FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", _
"FY08 Installation Support", "FY08 CF Discretionary Grants", _
"FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", _
"FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", _
"FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")

I need to set the height of all the rows to 18.00. I need to set the width of all of the columns to 12.00, except for columns A, C, and T, which need to be at a width of 28.00.

View Replies!   View Related
Formula To Calculate Row HEIGHT
I need a formula to calculate the height of a cell. Basically I will repeat this formula thoughtout the database, and each cell in column U will have its row height.

have come up with the following

Function RangeHeight(rng As Range) As Double
RangeHeight = rng.Height
End Function

Now, the problem is, that the formula does not automatically update when the row height changes, and when I open the file on another pc, all the formulas change to #NAME since it does not recognise the custom formula.

View Replies!   View Related
VBA To Autofit Row Height With A Minimum
I have a range named "rngOrders" on an Excel 2003 worksheet. I'm looking for a VBA macro that will set the row heights of the range to autofit (for rows/cells with wrapped text) and also set a minimum row height of 19.5 points for all rows.

View Replies!   View Related
Adjust By %
I would like to do some calculation with percentage as it showing in the attached file.

[url]

View Replies!   View Related
Picture Width And Height Adjustment
I need to paste a picture from the Clipboard to my Worksheet. I select the origin and paste it with the macro.

I need to adjust that picture to fit in a defined space from left corner of Range($J$10) to the right corner of
Range($BJ$35)

Actually, i'm using this procedure

ActiveSheet.Unprotect
RANGE("graphique_PL").Select
ActiveSheet.Paste
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Height = 358.25
Selection.ShapeRange.Width = 725.

The problem with it is, the Height and Width is arbitrary to the size of the cells at the moment. I would like to had a procedure to calculate does value. They represent the distance between the defined cells location for the image. Actually, if cells width or height change, the picture is misplaced.

View Replies!   View Related
Row Height Specifically For Page Breaks
I have a spreadsheet that I use for work that I have set the row height specifically for page breaks. I use the top 3 rows on each page as a header with that page info.

If I update it at home, then email it to work, the row height has changed. No real problem, I just go in and adjust the row height. Then if I email it back to home from work, it does the same thing.

It's just this particular sheet that does it. All of the other sheets that I use always keep their row height properties intact when emailing.


View Replies!   View Related
Set Height & Width UserForm Controls
I'm using a UserForm.Label to display comments which are of variable length. At the bottom of the UserForm are two CommandButtons. I'd like the gap between the Label text and the CommandButtons to be small (and preferably constant); and the CommandButtons to be at the bottom of the UserForm. This means setting the CommandButton.Top and UserForm.Height as a function of the Label.Height. The crude way I have so far achieved is to use Len(Label.Caption) as the surrogate for Label.Height but it's not very satisfactory due to word-wrap and blank lines.

View Replies!   View Related
Freeze Column And Row Height And Width
I need to freeze the column and row height and width for a specific area in spreadsheet, so that it shouldnt be altered in future from any one using this sheet.

View Replies!   View Related
Scale Height & Widths Of All Textboxes On A Worksheet
I have numerous Text Boxes on my worksheet. The number of these objects vary, as many will be continually duplicated/ deleted.

The code below is a simple recording of selecting each object and scaling.

VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy/pasting, but IS if the keyword uses "quotes" ...

View Replies!   View Related
Dynamic Userforms :: Code That Changes The Height Of A Userform
I am looking for some code that dynamically (during processing) changes the height of a userform. What I am trying to do is this: I have ten worksheets but only five are being used. I am looking to have a userform with a checkbox for each of the active sheets labeled. I don't want to have to display a form that is basically ten checkboxes with five enabled and five disabled. I want to show only the five active sheets checkboxes with a userform only large enough for the five. If six are active then a userform displaying six checkboxes and a userform large enough for only the six to be displayed.

View Replies!   View Related
Change Column Width And Height In Millimeters Mm
I have vba code to change column width and height into mm.
The code is taking alot of time to run and then hangs my excel session.
The code below calls two sub routines.

Sub Change()
Dim i As Long

With Application
.DisplayAlerts = False
. ScreenUpdating = False
End With

For i = 1 To 23
SetColumnWidthMM i, 3.5
Next i
End Sub...

View Replies!   View Related
Userform & Controls Scroll Height Width
I have a userform which has vertical and horizontal scroll bars. I want to set the scroll bar width and height properties to the correct value, regardless of the size of monitor screen used to look at the user form. I'm thought of using the code below in the initiliaze event for the user form:

Me.ScrollHeight = Me.Height
Me.ScrollWidth = Me.Width

However, this does not seem to work. I've tried adding 250 (Me.Height + 250)to each measurement, which works, but gives the user with the larger screen a very big scroll area. I wondered if there was a formula based on the application height, that would allow the scroll height to be perfect for the user form regardless of screen size?

Rico.

PS. I also use the following code to set the user form height on initialize. I don't know if that effects anything.

Me.Height = Application.Height
Me.Width = Application.Width

View Replies!   View Related
Setting Row Height To Font Cause Hidden Rows
I generated my spreadsheet in using vb6.
Everything is working except that when I display the display (making it visible), some of the data in the rows hides underneath the row lines. I have to physically go into the spreadsheet to expand the rows to see the hidden data. Also, if I print the spreadsheet, the hidden part of the spreadsheet is cut off unless I mannually expand the rows. How can I programmatically expand the rows to fit each amount of records in the row. Currently, I have a module that is mannually calculating the rows

Also, I have attached the spreadsheet so that you can see my output.

Below is the code that calculates and formats the row presently:

w = 0
For Each R In xlWksht. Range("A5:N5"): w = w + R.ColumnWidth: Next

rht = xlWksht.Range("A5").RowHeight

With xlWksht.Range(xlWksht.Cells(ii + 1, 2), xlWksht.Cells(ii + 1, 14))
.HorizontalAlignment = xlLeft
.VerticalAlignment = xlTop
.WrapText = True
.Orientation = 0
.MergeCells = True
.RowHeight = .Font.Size * (Len(xlWksht.Range("A" & ii + 2).text) - Len("Comments:")) / w + rht + (rht - .Font.Size) ' + newlinecnt * .Font.Size
End With

Below is my entire module:

ii = 5
w = 0
For Each R In xlWksht.Range("A5:N5"): w = w + R.ColumnWidth: Next

rht = xlWksht.Range("A5").RowHeight

'Do Until M.qBW.EOF = True
Do While Not M.qBW.EOF
ii = ii + 2
xlWksht.Cells(ii, 1).Value = M.qBW![Req No]
xlWksht.Cells(ii, 2).Value = M.qBW![Description]
xlWksht.Cells(ii, 3).Value = ""
xlWksht.Cells(ii, 4).Value = M.qBW![ClientName] & Chr(10) & M.qBW![Status]
xlWksht.Cells(ii, 5).Value = M.qBW![P L] & Chr(10) & M.qBW![TotalProg1Hrs] ...

View Replies!   View Related
Reduce Worksheet Scroll Bar Length/Height
I used to have cells in the extremes of my worksheet filled which resulted in the scroll bars being stretched very thin. Since then, I am only using the top-left part of the worksheet but it is difficult to scroll through since the scroll bars are still stretched. How do I bring them back to normal?

View Replies!   View Related
Change Chart Height & Width Code
How do I write a short piece of code that defines the specific height and width that I want to assign to an existing chart. The code will be added to existing code that I have that formats the chart in other ways. This needs to be able to work with any active chart selected, not a specific named chart.

View Replies!   View Related
Macro Adjust Row And Column
Is there a way to make a macro to make this true?


The WS is 300 rows,
The column width is 6.90

If LEN(B1)>147 then format ROW Height to 0.25
If LEN(B2)147 then format ROW Height to 0.25
If LEN(B300)

View Replies!   View Related
Adjust Date Format
I currently have dates in a column in the format DD.MM.YYYY. I would like to convert this into MM/DD/YYYY, with the slashes instead of the periods.

View Replies!   View Related
Make Subtotals Adjust
I have a piece of vba code that uses the date in column D to group by month and subtotal the amounts in column E.

The problem is the subtotal in column E doesnt adjust. So if a user of the spreadsheet adds or deletes rows the subtotals (and grand total) do not up date.

Dim LastRow As Long
Dim NextMonth As String
Dim R As Long
Dim Rng As Range
Dim SubAmount As Currency
Dim ThisMonth As String
Dim TotalAmount As Currency
Dim Wks As Worksheet

View Replies!   View Related
Adjust Margins Of A List
I have a list in excel.......(see attached) In the attached you will see some empty boxes for this purpose I have only provided a dummy duplicate. In the original I have information in these boxes.

Problem:
When i go to print preview the list boxes fall half way down the page instead of at the top of the page......when I try to adjust the margins in print preview, manually, or either in page setup it doesn't rectify it.

View Replies!   View Related
Adjust The Shape Of The Chart...
How to adjust the shape of the chart in the worksheet? I try to write the code, but can not work.

ActiveChart.Shapes.ScaleWidth 0.87, msoFalse, msoScaleFromBottomRight
ActiveChart.Shapes.ScaleHeight 1.5, msoFalse, msoScaleFromBottomRight

View Replies!   View Related
Adjust Zoom With Scroll Bar
I've used various "zoom" searches and can't find what I need. My users have different amounts of toolbars so the amount of screen space changes. I need to zoom so 4 graphs show. Am looking to enable the user with a scroll bar where the user could click / slide the control to change the zoom size on the screen so they can see the 4 graphs at their preferred "zoom".

I would prefer a control on the sheet and link it to a macro (or line of code if that's the proper phrase) and let the user decide (some people will want bigger zoom due to eyesight etc).

Private Sub ScrollBarZoom_Change()
ScrollBarZoom.Value = ActiveWindow.zoom.Value
End Sub

But I get Runtime error '424': Object required. Auto Merged Post Until 24 Hrs Passes;Nevermind. I found it. Answer was:

Private Sub ScrollBarZoom_Change()
ActiveWindow.zoom = ScrollBarZoom.Value
End Sub

View Replies!   View Related
Adjust Horizontal Pagebreaks
attached a sample, with the page settings, print area set, row height, etc... all set to my needs. I would like vba to adjust the horizontal pagebreaks so that a "box" is never split into two parts. in attached sample the pagebreaks should therefore go below row30, row54, row124 and row128. Setting pagebreaks is easy, but still want VBA to do it for me.

View Replies!   View Related
IF Formula- Comparing Height Vs Weight Standards Of Individuals
i am trying to use the following formula in a cell. it is comparing height vs weight standards of individuals....

View Replies!   View Related
Speed Up Macro That Adjusts Row Height & Column Width
This used to (and on some machines still does) work very well, but all of the sudden on my work machine, it is incredably SLOW!! The whole program takes a list of tasks and dates, and creates a wall calendar from them. Then (the offending part, below in code) looks at each cell on the wall calendar and formats it by sizing the height of a merged cell so that the entire task is displayed, then goes on to put a square around it (works fine).

The formating of the cell height/width can take up to 11 SECONDS each cell. What is happening to do this? Again, it USED to, and on some machines still does, FLY through this process. But now it just crawls. Code below, with the 3 offending lines identified.

Private Sub Fit_Height(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

Application. ScreenUpdating = False
With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next

An additional item (clue?) is that, after the macro is done running, it is still unbearably slow to do anything on-screen. Grabbing the column header and changing the column width takes 5 seconds or so before it snaps to the desired width and displays correctly. Closing Excel and reopening it takes care of that problem.

More advancement (as I wait). It seems to be the Application.PageSetup that kills it. As soon as I hit the first Application.PageSetup line, the app grinds to a halt, and almost every line after that that manipulates the screen format or the page format takes 5 or so seconds EACH to process. I put them all at the end, but that really doesn't solve the problem, nor explain it, nor give me a true solution.

View Replies!   View Related
Manipulate Chart Data Labels Height, Width....
I m working with bar charts and as I've heard these labels can be a bit of a pain. I've got the labels in roughly the right position 90% of the time however that other 10% has me in rolling fits.

My issues
1. A label within the chart area is wrapped on two lines, how could I restrict Excel from wrappign the label
2. A Labels position covers some of the data reported and thus makes the graph messy

how could I find the position of the end of the bar and also the length of the datalabel so I could reposition it. Note I am using 2003 and that I am trying to use

activeChart.seriesCollection(s).item(i).Datalabel.left

for finding the position although this is only really where im getting to. finding the wrapping position and also being able to manipulate the length of the label is proving tricky.

View Replies!   View Related
Sheet Protection Conflicts With Code To Autosize Row Height
When turning on sheet protection, I get an error with the following code that I'm using to make sure rows adjust their height when lines wrap.

Rows.EntireRow.AutoFit

What can be done to eliminate this conflict? All of the cells I want available for editing are unlocked.

View Replies!   View Related
Adjust Simple Formula To Find Last Row
I am using this formula in Cell J12: =AVERAGE($G$12:$G$85)

It will always be $G$12 but $G$85 needs to be done so that it goes until the last empty row on the worksheet.

View Replies!   View Related
Macro To Adjust Values In Columns
I'll admit I know very little about creating a macro in Excel so I hope someone can help me out with creating what I consider a fairly simple macro to adjust values in a column or columns.

What I am using this worksheet for is a merchandise database that contains 3 columns of pricing values, ie. Column headers Small, Medium, Large.

The columns are approximately 2000 rows deep.

I need to change the pricing values in all 3 of these columns by a specific amount. However there are some values in the "Large" column that will not be adjusted. Those values not adjusted will be based on the contents of another cell in the same row that would only contain the data "OT,JB" or only "JB".

I've considered using find/replace but think it would be very inefficient.

Right now I am looking to lower the price values by 2 dollars. All values are numerical and formatted as Number/General. ie, 11.95, 7.95

I've considered creating another column or linked worksheet and forumla-ize it and then copy/paste my value results back, but I am hoping for something less cumbersome, something that is expandable as the worksheet grows, etc. I think a macro, but I do not have any idea what to do or how to get started.

View Replies!   View Related
Scroll Bar Adjust Maximum Number
how to make vb Scroll Bar “Max” number to be equal to the next empty cell in column A in Sheet25. For example when A5000 cell is empty in Sheet25 then in Property of Scroll Bar Max setting would be 5000 and scroll bar must be at the position of max number.

View Replies!   View Related
Adjust Print Area Macro
The macro below works perfectly except for one problem. I only want it
to set the print area from Column A - Column M . It currently selects data i have in Columns N and beyond and i do not need that to print. From A - M is 13 columns.

View Replies!   View Related
Adjust Dates - Previous Months
I have a worksheet that displays totals from a master worksheet. At the bottom of the summary I would like to have the three previous months totals displayed from one column. I know that I can achieve this "quick and dirty" by just using VBA to display what I want, but I wanted to see if there was a better way of achieving this.

I searched and came up with a formula like[code = TEXT(H4,"MMMM"[/code] This will diplay the month name like I want, but there are also three other cells that I need the previous months in. Is there some type of formula that will autmatically change these values once the date in cell H4 changes?

View Replies!   View Related
Adjust Data Range Without Manually Filling Down
The below formula is in Col F6, how do i get this formula to adjust to data range without manually filling down, my data changes everyday therefore i need the formula to auto fill according to data range.

=IF(ISBLANK(E6),"",Summary!$I$2-E6)

View Replies!   View Related
Adjust Date Range Plotted On Chart
I am trying to get some help by adjusting my datarange dynamically based on what days I select. I would hope the chart could adjust to display for example 10/3/2008 to 10/10/2008 values and only those values.

I have been trying to figure out how the datarange varies in this post Dynamic Chart dataranges, I do not understand how to apply them to the charts source data. Ultimately Krish's chart would be ideal to understand and I belive is the keystone to where I am trying to go.

I have attached a sample of my workbook and the source data and chart I am trying to manipulate.

View Replies!   View Related
Adjust Formula To Allow For Changing Sheet Reference.
I was using the formula below which was working fine for copying across 20 columns and down however many rows, but now the requirements have changed to 90 columns. I have tested this out with the 90 columns but the Indirect function is bogging down the spreadsheet with the constant recalculating.

=IFERROR(INDIRECT("'"&COLUMNS($A$1:A$1)&"'!P"&ROWS($A$1:$A8)),"")

I rearranged the formula to the one below, but how can I have the reference to the sheet name changed as in the formula above without using the Indirect?

=IFERROR(INDEX('1'!$A$8:$AT$115,MATCH($A3,'1'!$A$8:$A$115,0),MATCH("PAT",'1'!$A$7:$AT$7,0)),"")

The sheet reference will change from '1' through '90'.

View Replies!   View Related
Dynamic Name Ranges Don't Adjust When New Range Inserted?
the dynamic name ranges I had created did not "adjust" in their position references when I added new name ranges later.

My workbook (see attachment) Master sheet has several name ranges that are based on their position to a key name range I set up..."Unit". Example below:

"Unit"

View Replies!   View Related
Adjust Chart Source Range Via Combo Box
I have various charts others view and require the data range to change in 12 month intervals, ie Jan07 -Jan08, Feb07-Feb08. I currently move the ranges manually every month but find the it would be more interactive for others if a drop down combo box on the chart were used enabling the user to choose which intervals to view.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved