Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 06-16-2014, 07:38 AM
BobBridges's Avatar
BobBridges BobBridges is offline NEWB to Macros - formatting exports Windows 7 64bit NEWB to Macros - formatting exports Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, a few questions:

1) In the workbook I've loaded at this end, the three columns you name for deletion—"Baseline Start", "Baseline Finish", and "Resource Names"—are not E,G,J as you said originally, nor E,H,J as you say this morning, but F,H,K. You say you add the first column, ID #, and if you mean you add that manually after the macro is run then that would be E, G and J again. So I'm just checking that that's what you meant...?

2) "Export"? What export? So far all I know about is coloring rows. Don't get me wrong, export is fine; but if you're doing something more than I thought, I want to know what it is in case it affects the macro.

3) If you're planning to add the ID# column every time, after the macro is run, why not have the macro do it for you? One less thing to do manually. But we can add that later; it doesn't have to be now.

I notice one other thing about this worksheet, which isn't exactly a question but I'll add it to the others:

4) We've been talking about doing this to rows 1 through 264; but row 1 contains column headers. The program as we've discussed it wouldn't change change the color of row 1 (because it has neither "Phase" nor "Sub-Phase" in the "View Filter" column), but we may as well change it to run from 2 to 264 instead.

Other than the above, I think the program looks about right. Now: Do you know how to get Excel to run that program? Should we walk through it step by step, or do you already know what to do next?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting contents after Tab of continuous lines or formatting specific area of word pawii Word 1 05-12-2014 05:24 AM
macros stebrownsword Word VBA 0 08-28-2013 01:16 AM
NEWB to Macros - formatting exports How to do Formatting Using Macros anju16saini Word VBA 1 03-11-2013 04:15 AM
NEWB to Macros - formatting exports Formatting with macros WaltR Word VBA 8 05-15-2012 06:28 PM
Macros nore Outlook 0 06-01-2011 04:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft