+ Reply to Thread
Results 1 to 2 of 2

place a cursor using Cell(Column, Row)

  1. #1
    Registered User
    Join Date
    06-13-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    1

    place a cursor using Cell(Column, Row)

    In my macro, I have defined FOR loop for first 100 rows as below

    For i = 1 To 100

    If Sheet2.Cells(i, 3).Value = "" Then
    Cancel = True
    MsgBox ("message data")
    Exit For
    End If

    I am using cell(i,3), cell(i,4) and so on to validate the value in each cell. Now if there is an error in any my validation, I need to place the cursor. The challenge is I am using cell(i,3) and I don’t know how to use it in Range(“ “).Select

    Please help

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: place a cursor using Cell(Column, Row)

    Hi, foolfellow,

    please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure. And maybe you should post the whole procedure including the header as Cancel doesn´t make much sense to me in this sniplet.

    Ciao,
    Holger
    Last edited by HaHoBe; 10-06-2015 at 03:01 AM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. Replies: 5
    Last Post: 06-17-2015, 08:48 AM
  2. How to expand check box when you place cursor on it?
    By jgomez in forum Excel General
    Replies: 0
    Last Post: 03-24-2011, 10:45 AM
  3. Replies: 1
    Last Post: 10-01-2007, 07:46 PM
  4. Place Cursor at Bookmark
    By Wakey1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2007, 04:23 PM
  5. Keeping cursor in same place on all worksheets in a workbook
    By Phil Burgess in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2005, 09:32 AM
  6. Replies: 3
    Last Post: 01-31-2005, 08:06 PM
  7. Macro ( Move cursor 1 place to the left)
    By WayneF in forum Excel General
    Replies: 2
    Last Post: 01-27-2005, 11:06 PM

Tags for this Thread

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