+ Reply to Thread
Results 1 to 3 of 3

coding error when trying to chanage code to work on same sheet but different area

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    44

    coding error when trying to chanage code to work on same sheet but different area

    I have had a problem within my spread sheet where it would not allow me to retain data and overwrite it, and I was advised to implement VBA code.
    here is the vba code with annotations
    Please Login or Register  to view this content.

    End Sub
    The code that was created works perfectly however the coding ends where the ‘KS5’ section ends , is it possible to have the same code run through the sheet so that the same effect happens? however it must be dependant on the KS4grades/Effort and KS3grades/Effort toggle options respectively. i have also attached a spreadsheet which also conatins the coding used Attachment 131748
    Last edited by jabjab; 12-07-2011 at 12:54 PM.

  2. #2
    Registered User
    Join Date
    10-03-2011
    Location
    Quebec, Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: problems with coding that im using

    You should make sure your title (of this forum post) is more descriptive

  3. #3
    Registered User
    Join Date
    10-07-2011
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: problems with coding that im using

    i dont really know how to write the coding for it and i have tried to edit it to work on the othere area nut it hasnt been succesful any help on this problem
    Last edited by jabjab; 12-07-2011 at 12:56 PM.

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1