+ Reply to Thread
Results 1 to 5 of 5

Need vba to fill format the datevalue in column right till end of value and formula across

  1. 08-31-2016, 08:46 AM #1
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Need vba to fill format the datevalue in column right till end of value and formula across

    Dear Expert

    There are two types of report range in which I want fill the format in row start from C19 till end of value in column right as well as second range start at C27 fill the format with remove the Sum of" and keep the date rest.

    i want fill format on date cell and fill the formula below row. now its C19:AN19 & C27:BM27
    The Date row left get change depends upon report its not standard one so i want code equalize the column values till end of column values start from C19 & C27

    Please find the attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-31-2016, 11:40 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need vba to fill format the datevalue in column right till end of value and formula ac 

    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 With QuoteRegister To Reply
  3. 08-31-2016, 12:19 PM #3
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need vba to fill format the datevalue in column right till end of value and formula ac

    Sir Can u add code for Background Color apply?
    Reply With QuoteRegister To Reply
  4. 08-31-2016, 01:04 PM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need vba to fill format the datevalue in column right till end of value and formula ac

    You can record a macro and make format changes to get example code. Then use that example code in the DBD macro.

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 08-31-2016 at 01:07 PM.
    Reply With QuoteRegister To Reply
  5. 09-01-2016, 10:07 AM #5
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need vba to fill format the datevalue in column right till end of value and formula ac

    Amazing Solved!! Perfectly
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to fill the formula across row and column till total
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2016, 09:25 AM
  2. [SOLVED] Help On VBA code to run till end of workbooks In path Avoid datevalue of Input
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2016, 03:18 AM
  3. [SOLVED] VBA to fill the formula in every set of range till end of row data
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2016, 10:50 AM
  4. [SOLVED] VBA to fill formula down till last row in column
    By Wither125 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2016, 06:03 PM
  5. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  6. Help with Macro: I need to fill columns D-N only up till the row number in column A
    By zizou0178 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2014, 02:16 PM
  7. Select a specific column till it identifies blank cell and to format
    By k1234y in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2012, 12:35 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1