Cell Ranges And Have Lines And Shapes Come Along For The Ride, And Disembark With The Same Orientation

Aug 22, 2007

I'd like to just copy or move cells or cell ranges and have lines and shapes come along for the ride, and disembark with the same orientation. E.g. if cell E29 has an arrow through his head, I'd like AA66 to after copying there.

I haven't got the knack of when I've selected enough to grab the shape. Sometimes I think I've got it but when I paste I discover that the slippery critter stayed at home. But sometimes I just cut one cell and the shapes move too.

Any advice? BTW, I stay on the keyboard, and off the mouse, as much as possible - I'd like to avoid slowing down to make mouse selections.

View 9 Replies

Define Name For Lines/shapes

Feb 10, 2008

Is there a way to define a name (Insert-->Name-->Define) for lines and/or shapes drawn using the Drawing toolbar?

I'd like to assign a specific name to a rectangle I've drawn outside of the sheet print limits. By using an If-Then formula, I'd like to bring that shape into a specified cell based on the conditions of the If-Then statement.

View 9 Replies View Related

Getting Cell References To Change Orientation

May 13, 2007

I would like to reference cells in another tab in my worksheet, but change the orientation.

For example, in Tab 2, I want to make rows A1:A26 equal to columns A1:Z1. Do I have to click back and forth between worksheets 26 times, or is there a way around this?

View 12 Replies View Related

Ride Beetween Two Userforms

Jul 14, 2006

Is there any way to have two userforms open and change from one to other just by click in it.

Ex:

just like windows does, we can have two windows opened and go from one to other just by click in it.

View 3 Replies View Related

Creating Shapes (Rectangles And Shapes) From Input Cells?

Aug 30, 2013

Im trying to create shapes Rectangles and Squares with different colours within an excel sheet, where the length and height of the shapes is generated by input values.

Also is it possible to create 3D shapes, again where the size of the shap is generated by input cell values.

View 1 Replies View Related

Listbox Does Change Orientation

Aug 10, 2009

I have a listbox that gets filled via '.rsRS.GetRows', which works great; all rows are being displayed neatly.

However, when the recordset only holds one record, i.e. one row is desired to appear in the listbox, then the listbox changes its orientation: instead of one row with seven columns I get one column with seven rows!

The listbox properties in the local window states that the lbx.List() object has a column count of '7', but what I see looks like:

[] name
[] surname
[] age
[] zip
[] colour
[] dob
[] phone

It should look like:

[] name surname age zip color dob phone

View 9 Replies View Related

Set Print Orientation On All Worksheets

Feb 8, 2008

how would I change the orientation on ALL my worksheets, I'm saying every single one, imagine I got like 100 for the purpose of this excercise (sorry I'm not trying to make this harder, it's just there's always that one guy that'll come on and say 'Go to Print Print Preview, then click on Setup' or something like that.

So yeah, that's pretty much the question that I have for you brainaics:

How do I change the printer orientation setting to landscape on all worksheets (maybe a loop?).

View 3 Replies View Related

Color Of Shapes From Cell Content

Jul 3, 2014

I made a little macro to change the color of a circle whether my cell value is positive or negative.

However, I'm looking for a way to code it in ThisWorkbook sheet so that the code runs by itself every time the cell value changes.

[Code] .....

View 1 Replies View Related

Formula To Manage Output Orientation

Feb 9, 2010

View 9 Replies View Related

Changing Page Orientation For Different Pages?

Jan 28, 2014

I've created a workbook with several pages, on all of the first pages they are set up in Landscape view since it contains several columbs of accounting amounts. Below each (page 2) I would like to create a receipt template that I can use the sum formulas and text formulas which is no problem. However, when I print the selected page 2 of 2 to get the invoice, it also comes out in landscape set up. Can I have one page (ie: rows 1-44) in landscape and then page two (rows 45-83) in portrait.

View 2 Replies View Related

AutoFilter By Rows (with Orientation - Left To Right)?

Jun 17, 2007

Is it possible to use AutoFilter by Rows (with Orientation - Left to Right)?

View 9 Replies View Related

Changing A Graph To Vertical Orientation

Jun 17, 2007

I have a normal line graph I would like to see plotted vertically rather than the normal horizontal layout. In other words, points/lines would appear around a vertical axis and go from side to side. The normal graph would look as if it was tipped on its left side.

View 9 Replies View Related

Unable To Set The Orientation Property Of The PivotField

Oct 15, 2006

I want the data field to change to a different field when a command button (cmd_view) is clicked. So when the command button has a caption of "Toggle to Feeds", the code changes the field from Sqm to Feeds, and changes the caprion on the command button to "Toggle to Sqm". When this is next clicked, the fields are swithed over, and the command button caption changes relative to it.

The code I have written is below:

The problem I have is when the code changes the view from feeds to Sqm, it works fine, but when the code changes from Sqm to feeds, it crashes out in the true part of the If statement on the code line ".orientation = xlhidden" with the error "Unable to set the Orientation property of the PivotField class".

As the code for the change of view is the same, apart from the field names, I am at a loss on what is the cause.

I have tried to record a macro to see if the field names appear differently, but they do not.

Sub Tog_pivot()

Dim Toggle As String
Application.ScreenUpdating = False
Toggle = Sheet5.cmd_View.Caption

If Toggle = "Toggle to Feeds" Then
'switch view from Sqm to Feeds
Range("F12").Select
' hide existing field
With ActiveSheet.PivotTables("Pivot_forecast_old").PivotFields("Sum of Sqm")
.Orientation = xlHidden
End With
' Create & display new field "Feeds"......................

View 9 Replies View Related

Display Or Hide Shapes Based On Cell Value Without VBA?

Aug 8, 2012

I have a map of the US composed of 50 shapes (one for each state). I need each shape to appear or disappear based on a value in a corresponding cell. I can't use VBA for this as it needs to function for users in a high-security Excel 2003 which doesn't allow macros.

View 1 Replies View Related

Shapes Or Angles Based On Cell Data

Apr 17, 2008

Can Excel Draw Shapes or Angles based on Data? I have a radiation Excel file that solves for Radiation intensity using Distance and shielding as reducing factors. Similar to a circle of light being less intense with distance so is radiation. I need excel to draw a circle from a point specified based on a value I give. For example at 1 ft I might have 500 R in 1 hour (life threatening!) At 16 feet I have about 2 R in 1 hour (not safe for too long). These circles would be overlayed on an map. I would like to draw a new circle at various distances, simialar to a bullseye.
I would also like a triangle drawn based on angles and SIN / COS / TAN formulas

View 2 Replies View Related

Custom Toolbar Orientation. Horizontal & Vertical

Oct 13, 2007

How do you control the orientation of a floating toolbar? The code below puts the elements horizontally, while I'd like to make the toobar have a vertical format (one macro per line). I'd also be interested if there's a way to do sub-menus to organize the toolbar buttons better. how to revise the code below, and/or a pointer to where I can read about this. I tried searching google and this forum to no avail.

Option Explicit
Public Const ToolBarName As String = "My Toolbar"
Sub Auto_Open()
Call CreateMenubar
End Sub
Sub Auto_Close()
Call RemoveMenubar
End Sub
Sub RemoveMenubar()
On Error Resume Next
Application.CommandBars(ToolBarName).Delete
On Error Goto 0
End Sub
Sub CreateMenubar()......................

View 2 Replies View Related

Autosize Cell Comments/Shapes Via Macro Code

Aug 25, 2006

Among many attempts to insert and autosize a comment using VBA manually, which errored, i recorded the following bit. When running the macro, it does format the cell - text, not the comment - text and errors in the line highlighted in red.

Range("A14").Select
Range("A14").AddComment
Range("A14").Comment.Visible = False
Range("A14").Comment.Text Text:="Ladida"
With Selection
.HorizontalAlignment = xlLeft
.VerticalAlignment = xlTop
.ReadingOrder = xlContext
.Orientation = xlHorizontal
.AutoSize = True
End With

I just want to add

.AutoSize = True

or something to that effect to the bit below. Any suggestions?

Range("A14").Comment.Text "Ladida"

View 5 Replies View Related

Excel 2007 :: Change Orientation Of Entire Application

Apr 11, 2012

Someone Im working with says she used to change Excel to work on it on some vertical monitor. Is there a way to do that in Excel 2010 or even 2007?

Obviously I'm not talking about print layout, but viewing the whole application in portrait view, as if she turned a monitor sideways and altered the Aps view.

View 6 Replies View Related

Fill In Vertical Values To Selected Area With Horizontal Orientation

Feb 20, 2013

I want to put vertical values to a selected space with horizontal orientation

See the excel file : FILL IN SELECTED DATA.xlsx‎

View 9 Replies View Related

VBA To Insert Lines When Cell Value Changes

Feb 12, 2014

I have this code:

[Code] .....

The first change in column K it finds perfectly but then it enters a lot of blank rows and does not put blank rows at the rest of changes in column K.

View 2 Replies View Related

Populating A Cell From Different Lines

May 5, 2007

I am trying to make sheet that will give me averages from different groups within a worksheet. In E64 I would like to have the total that is in I4 unless there is a total in I24 or I44. When I made the worksheet, it figures everything great but when I remove the data on following weeks it messes up the averages.

View 10 Replies View Related

Parsing 2 Lines Of Addresses In One Cell

Mar 27, 2014

I have the attached spreadsheet that has 176K of addresses. The cell contains data that is actually Address Line 1 and Address Line 2. I need to separate these. I believe there is an unprintable character that separates most of them -- maybe a CRLF or something like that.

See the attachment for examples ... Cust Address with unprintable characters.xlsx

View 5 Replies View Related

Delete Lines In A Multiple Cell?

Aug 5, 2014

TTHBF251863100

147943F00KNQ TTHBF251863100
REF VINS DU MONDE SA
O/RTT HBF251863100

I need a macro to transform my multiple lines cell as above ( 5 lines ) into a one line cell as below.

REF VINS DU MONDE SA

As the cells needing changing will always be different it would be good if I could have a macro working on the selected cells only, not a specified range.

View 1 Replies View Related

Format Specific Lines Within A Cell

Jul 7, 2009

I am trying to write a macro that given a selected range of cells goes in each cell and bolds the first 2 lines within the cell. An example of this would be if the cell contained:.............

View 2 Replies View Related

Combine Several Lines Of Text Into One Cell..

Oct 23, 2008

In column A I have product names, in B I have product categories and in C:H the product categories from column B are titles and the name of the subcategory is written in the cell. Because there are mutlipule sub categories that a product can belong to the report produces mirrored lines with one sub category on each line. What I need to do is combine all of these subcategory entries into one cell separated by a comer (,).

View 2 Replies View Related

How To Remove Blank Lines Within A Cell

Nov 17, 2011

In Sheet1 cell A1 has concatenate formula and the data source is linked from sheet "DataInput". Sheet1 cell A1 has multiple data and there are blank lines within the cell. I would like to remove these lines so it looks clean without any gaps. So basically its looking like this right now

Harry

Andrew
Joe
Apple

Billy

I want it to look like this but i am having a difficult time because this cell contains a formula

Harry
Andrew
Joe
Apple
Billy

A formula or something that would fix this problem automatically.

View 1 Replies View Related

Extracting Value From Multiple Lines In Cell?

Jun 7, 2012

I have values in a column of cells in the format (All numbers in a single cell)

34567,43510,'1'
44049,99820,'1'
11124,37373,'1'
etc

up to ten such entries may appear in each cell with an arbitrary number in each cell. They were entered using the ALT+Enter method. Is there an easy formula to extract each row (such as 44049,99820,'1') to use in a formula. If there are two entries I would like to write two separate rows like:

LINE 34567,43510,'1'
LINE 44049,99820,'1'

If a macro would be required I understand and could use that also.

View 1 Replies View Related

Trimming For Multi-Lines In Cell

Aug 11, 2013

How to trim when there are many lines in cell. The normal trim works only when we have one line in a cell.

View 9 Replies View Related

Remove Cell / Grid Lines

Dec 31, 2007

I have created a form for my customers. It is attached.

In creating the form, I have merged cells so that the area behind my text boxes will appear clean (no lines).

However, I cannot remove the lines around certain cells see, e.g. range K21.

I would like to make the form as "pretty" as possible for my clients (and it would help me look good to management).

View 4 Replies View Related

Pasting Multiple Lines Of Text Into One Cell?

Jul 24, 2014

I am trying to cut and paste from a PDF document into excel and a grab of text when pasted sits in three boxes instead of one. How can I manage this?

View 9 Replies View Related