+ Reply to Thread
Results 1 to 2 of 2

save to other sheet

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    NL
    MS-Off Ver
    7
    Posts
    14

    save to other sheet

    Hi,

    I have a problem with saving a vba userform .
    The data is stored in a database "gegevens" , now I want them stored in another sheet " gegevens2 " but I can't get out off it.
    For example: The textboxes must be stored in : gegevens2 Cell B2 to X2, and everytime that i stored a new data, the can save over the old data
    self i try to rename some things data : like gegevens2 and For Each c In MyRange.Range("B2:B2000") but it won't work

    Can somebody help me.

    Thanks en sorry for my bad english

    greets

    Paul


    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: save to other sheet

    missing before and after sheet


    Kind regards
    Leo

+ 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. Save the current worrkbook, save the sheet as .csv and close the workbook
    By SpeediWeb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2015, 06:50 AM
  2. Save the open sheet in a path with a save as dialogue box and also create two folders
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2015, 05:19 PM
  3. Replies: 2
    Last Post: 01-27-2015, 03:16 PM
  4. Save one sheet, and save work book as back up
    By ryanlee84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2014, 03:58 AM
  5. [SOLVED] VBA to save active sheet as new file with save as option
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2013, 10:54 AM
  6. Replies: 4
    Last Post: 08-16-2010, 09:54 AM

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