+ Reply to Thread
Results 1 to 2 of 2

VBA variable declaration and assignment help

  1. #1
    Registered User
    Join Date
    02-06-2017
    Location
    California, US
    MS-Off Ver
    Office 2016
    Posts
    38

    VBA variable declaration and assignment help

    I am having trouble with the code in red. I would like to first search for the first empty cell in column C on Sheet1 then search on another sheet for a specific value to move over to the first empty cell in column C in sheet1.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA variable declaration and asignment help

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. [SOLVED] Meaning of characters in %, !, $ and # in variable declaration
    By Plotseling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 04:59 AM
  2. [SOLVED] Conditional public variable declaration
    By RedWing in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-13-2012, 11:16 AM
  3. [SOLVED] Variable Declaration issue
    By NewToCode in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2012, 01:57 PM
  4. passing a variable to an array declaration
    By labogola in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2012, 04:10 AM
  5. Range Declaration using Variable
    By wfire in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2009, 11:43 AM
  6. Changing variable value without explicit declaration
    By carg1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2007, 02:42 PM
  7. A disturbing behaviour of DIM (for variable declaration)
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2005, 01:20 PM
  8. [SOLVED] Declaration of public variable - Question
    By Les Stout in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2005, 10:05 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