+ Reply to Thread
Results 1 to 5 of 5

Working with ranges

  1. #1
    denny
    Guest

    Working with ranges

    1. In my old dos program, Lucid, I could mark a range and make it all be
    LABEL, which meant it would move to the left and show the formula plus and
    apostrophe in front of it. In Excel, can I put an apostrophe in front of a
    whole bunch of cells at once?

    2. Can I use <F4> to change a whole range from looking like- $A$1 to
    looking like $A1?

    3. How can I show formulas in one range of cells?

  2. #2
    Tom Ogilvy
    Guest

    Re: Working with ranges

    Either formulas or results are shown - there is no mix and match.

    You can removed the = sign or precede the formula with a single quote and
    the formula becomes a text string and is displayed.

    There is no build in support for doing this other than editing the cell.

    F4 applies to what is selected in the formula bar. Unless you are working
    on a multicell array formula or filling the range, it doesn't work on
    existing formulas in multiple cells.

    --
    Regards,
    Tom Ogilvy

    "denny" <denny@discussions.microsoft.com> wrote in message
    news:99B22F23-22C6-4D05-B8A4-C6E7146900CD@microsoft.com...
    > 1. In my old dos program, Lucid, I could mark a range and make it all be
    > LABEL, which meant it would move to the left and show the formula plus and
    > apostrophe in front of it. In Excel, can I put an apostrophe in front of

    a
    > whole bunch of cells at once?
    >
    > 2. Can I use <F4> to change a whole range from looking like- $A$1 to
    > looking like $A1?
    >
    > 3. How can I show formulas in one range of cells?




  3. #3
    denny
    Guest

    Re: Working with ranges

    How can I make a macro that uses <F2><Home><'><Enter>
    and will repeat itself downward for as long as cells are occupied...from any
    column you start it in



  4. #4
    Dave Peterson
    Guest

    Re: Working with ranges

    One way:

    Option Explicit
    Sub testme()
    Do
    If IsEmpty(ActiveCell) Then
    Exit Do
    Else
    ActiveCell.Value = "'" & ActiveCell.Value
    ActiveCell.Offset(1, 0).Activate
    End If
    Loop
    End Sub



    denny wrote:
    >
    > How can I make a macro that uses <F2><Home><'><Enter>
    > and will repeat itself downward for as long as cells are occupied...from any
    > column you start it in


    --

    Dave Peterson

  5. #5
    denny
    Guest

    Re: Working with ranges

    Thank you. That worked perfectly!!! Please look at Shelling Out to Dos

    "Dave Peterson" wrote:

    > One way:
    >
    > Option Explicit
    > Sub testme()
    > Do
    > If IsEmpty(ActiveCell) Then
    > Exit Do
    > Else
    > ActiveCell.Value = "'" & ActiveCell.Value
    > ActiveCell.Offset(1, 0).Activate
    > End If
    > Loop
    > End Sub
    >
    >
    >
    > denny wrote:
    > >
    > > How can I make a macro that uses <F2><Home><'><Enter>
    > > and will repeat itself downward for as long as cells are occupied...from any
    > > column you start it in

    >
    > --
    >
    > Dave Peterson
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06208 seconds
  • Memory Usage 8,901KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_legacy
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1