Results 1 to 18 of 18

VBA Worksheet selection, is it possible select the range

Threaded View

Motilulla VBA Worksheet selection, is... 10-03-2024, 06:02 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 06:17 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 06:40 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 06:56 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 07:09 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 07:13 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 07:20 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 07:41 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 07:48 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 07:55 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 08:34 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 08:49 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 09:41 AM
AliGW Re: VBA Worksheet selection,... 10-03-2024, 09:43 AM
MikeVol Re: VBA Worksheet selection,... 10-03-2024, 10:14 AM
JohnTopley Re: VBA Worksheet selection,... 10-03-2024, 10:21 AM
Motilulla Re: VBA Worksheet selection,... 10-06-2024, 01:40 AM
Motilulla Re: VBA Worksheet selection,... 10-03-2024, 10:17 AM
  1. #1
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    545

    VBA Worksheet selection, is it possible select the range

    Using Excel 2010
    Hello,

    Select 4 rows and 15 Columns (in the column D:R) when any cell is selected in column range D9:D19 ((if the range is empty then no selection)

    For example If Cell D9 is selected Select The range D6:R9

    And when D10 is selected (select the range D7:R10) and clear D6:D9 selection

    Note: if the selection option is not possible highlight the range in yellow

    Example workbook attached

    Regards,
    Moti
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Repeating Fruits on selection or prompting to select range for selection
    By Ekac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-05-2024, 09:30 AM
  2. [SOLVED] Select Defined Range if Selection
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2014, 06:20 AM
  3. [SOLVED] Copy Data Range & Paste at Selection.End(xlDown).Select
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 06:15 AM
  4. [SOLVED] Range(Selection, Selection.End(xlDown)).Select goes to 65536 instead of last filled row
    By looney in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-12-2013, 10:51 AM
  5. Replies: 2
    Last Post: 04-20-2012, 12:23 PM
  6. Selection.Replace replaces in entire workbook despite Range.Select
    By robapodaca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2011, 08:23 PM
  7. Deselecting the Range().Select selection?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 10-03-2011, 04:16 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1