+ Reply to Thread
Results 1 to 7 of 7

Problems in VBA codes when inserting in Cell A1

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    325

    Problems in VBA codes when inserting in Cell A1

    Please see my attachment .

    I am putting a model e.g."FND" in cell A1 in file -HM1D Copy
    then the problem comes and not insert the "FND" in each month.

    The message is appearing : Method Insert of object Range failed ". Please see the capture file i.e.PNG file.


    How can I correct my VBA codes sothat I could insert what I type in cell A1 in excel file.

    Excel version=MSoffice 16
    Windows=10
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,672

    Re: Problems in VBA codes when inserting in Cell A1

    Hi Pradeep

    How can I correct my VBA codes
    We will first have to see your code to be able to answer that question...Also you do not explain what you are actually wanting to achieve...

    am putting a model e.g."FND" in cell A1 in file -HM1D Copy
    In what sheet?
    What is "FND"?
    then the problem comes and not insert the "FND" in each month.
    What does this mean?
    Last edited by sintek; 09-11-2020 at 07:24 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    325

    Re: Problems in VBA codes when inserting in Cell A1

    File is HM1D-Copy and sheet is Veh.Reco

    Put any type like FND in cell no.A1 in place of GLMLDSSCF.

    It should be insert in column B in each month and in ascending order.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,672

    Re: Problems in VBA codes when inserting in Cell A1

    Please Note…
    Quoted From Rick Rothstein
    One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more. Also, uploading an actual file (see yellow banner near the top of this forum's window) showing your data as it exists and on another sheet showing how you want it to look after being processed would help immensely.

  5. #5
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,040

    Re: Problems in VBA codes when inserting in Cell A1

    without your current code and probably a copy of a workbook displaying the problem, it is unlikely you will get a solution. I echo Sintek's comments

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,672

    Re: Problems in VBA codes when inserting in Cell A1

    Pradeep...Are you wanting the text that you type into A1 to be populated as a last entry for every date in Col A and then to sort the info?

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,672

    Re: Problems in VBA codes when inserting in Cell A1

    In Sheet Module...
    Please Login or Register  to view this content.
    In Std Module...
    Please Login or Register  to view this content.
    Last edited by sintek; 09-12-2020 at 12:55 PM.

+ 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. Inserting a map chart using UK Postal Codes
    By michelle 1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-19-2019, 02:00 PM
  2. Inserting constant codes a cell
    By Uchi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2019, 09:53 AM
  3. [SOLVED] macro codes for inserting formula to various similar worksheets
    By rohit43 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-21-2013, 10:17 AM
  4. Mac Excel problems inserting columns
    By adb_bliu in forum Excel General
    Replies: 0
    Last Post: 08-28-2011, 02:52 AM
  5. Replies: 6
    Last Post: 11-28-2006, 01:08 PM
  6. Problems inserting rows
    By KathleenK in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 10:04 PM
  7. Cell Problems after inserting value with VBA
    By DaveUK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2005, 03:39 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