+ Reply to Thread
Results 1 to 3 of 3

Range("xy").Formula - how to write it?

  1. #1
    Forum Contributor
    Join Date
    07-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2019
    Posts
    244

    Range("xy").Formula - how to write it?

    Hello,
    I have one macro in which I need to use this formula, but I cannot use this formula in cells but in macro ... how should I write it?

    Please Login or Register  to view this content.
    - this is from cell ... this works, but in macro there has to be different code ... any help please?
    Last edited by miso.dca; 10-27-2013 at 05:11 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,754

    Re: Range("xy").Formula - how to write it?

    Try this:

    Please Login or Register  to view this content.
    You will need to surround the entire formula in quotation marks and each item surrounded in quoatations will require double quotations. Addditionally, I am not sure if the semi colon syntax works in VBA. I have changed them all to commas.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    07-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2019
    Posts
    244

    Re: Range("xy").Formula - how to write it?

    thx alansidman ! It seems that your solution works and yeah there has to be commas, that I know but how about quotes
    tomorrow (after I will be sober ) I will change problem status to SOLVE

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If formula to return "yes" or "no" answer from a range of cells
    By mfairhurst1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2013, 05:00 PM
  2. [SOLVED] how code do i need to write before "RANGE("A1").value to access a specific worksheet?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 03:46 AM
  3. Strings Variables in Range("A1").Formula = "=index/match" ?
    By nadnerb5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 05:07 PM
  4. How to write cell address of the match in this , =IF(COUNTIF(A:A,B1)>0,"x","")
    By sureng19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2010, 08:03 PM
  5. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 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