+ Reply to Thread
Results 1 to 3 of 3

code doesn't work when i change.

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    code doesn't work when i change.

    New Compressed .zip
    I have this code
    HTML Code: 
    I am trying to edit it and when I remove the r. offset(0,1).value = now and replace with

    HTML Code: 
    also added
    HTML Code: 
    It just ingores it. can't figure out why.Attachment 377384

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,355

    Re: code doesn't work when i change.

    Hi superchew,

    What does .End(3)(2) do in your code?

    The only thing I use after .End are the following
    .End(xlUp)
    .End(xlDown)
    .End(xlToRight)
    .End(xlToLeft)

    What am I missing?
    https://msdn.microsoft.com/en-us/lib...ffice.11).aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: code doesn't work when i change.

    not trully sure. I have received alot of help from other awesome members of this forum trying to get this right

+ 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. Code Used to Work and Now It Doesn't - No Change in Book Though?
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2012, 06:35 AM
  2. [SOLVED] change position in VBA of chartobject doesn't work
    By MarMo in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-12-2012, 01:37 PM
  3. worksheet change doesn't always work
    By damorrison in forum Excel General
    Replies: 1
    Last Post: 05-29-2006, 06:38 AM
  4. [SOLVED] Why doesn't ths VBA Code work?
    By Mac Lingo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2005, 10:10 PM
  5. [SOLVED] vba code doesn't work
    By lschuh in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-22-2005, 02: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