Search:

Type: Posts; User: mobilepoker

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    791

    Add a range to a selection

    Hi,

    I want to add a new selection to a previously defined selection.

    I am very bad at using range object even after studying its usage. Here is what I am trying:

    Range(Selection, ActiveCell,...
  2. Select non-consecutive columns with a VBA macro

    Hi,
    I am trying to write a VBA code that automatically detects the end of columns (until it reached a blank cell). Then selects the columns of the user-selected cells.

    Here is the sub I am...
  3. Re: Cannot debug 'Subscription out of range error'

    But the line Set r = Application.InputBox("mention the range", , , , , , , 8) already stores a range in the variable r, doesn't it?
    The type 8 in the application.inputbox mentioned above is for...
  4. Cannot debug 'Subscription out of range error'

    Hi I am writing a VBA code for getting data from different workbooks and combining them in a single one. However, I am getting the 'Subscription out of range error' in the bold line of code below. I...
  5. Replies
    2
    Views
    874

    Function not running from excel

    Hi, I am executing the below mentioned function like a formula in excel worksheet. But it is not giving the desired output ie. selecting 8 rows below the activecell.
    However, it is working fine if I...
  6. Re: Why don't we use double quotes when working with variables?

    Thank you for the detailed explanation. I am new to programming and learning it from Coursera. I will make sure to check other basic tutorials next time.
  7. [RESOLVED] Why don't we use double quotes when working with variables?

    Hi, while writing a cell address in a range object I need to use double quotes
    example: range("B5").select
    But when I use variables for defining an address I don't require double quotes ...
Results 1 to 7 of 7



Click Here to Expand Forum to Full Width