Search results for query: *

This is the code that I created to try to shade columns, representing months, within each row based on the combination of the leadtime and a 2-digit month code. The objective: When looking at the 2-digit code for each row, start shading the month (corresponding column "1" for Jan...

Hello, My goal is to shade cells that represent certain months. For example, within Excel if A2 through A17 shows 1,2,3,4,5,6,7,8,9,10,11,12, 5,6, 8,2, (numbers represent the month number i.e. 1 for Jan.) and b1 through b12 shows Jan, Feb, Mar,....Dec I want to shade 5 columns starting with...

I am trying to format an area from j2:aj2. Within this range, for each row the has "Price" in column "J" I need that row to be formatted as "currency", and every other row should be formatted as "comma without decimal places". I have tried to develop the...

Does anyone know what VBA code to insert to prevent the visual display of a macro being run? dyana

I would like VBA code that builds an icon and places it into the existing Excel toolbar. I have tried to record a macro that creates a custom macro and alters the color and display of the icon that was placed into the toolbar and assigned to a macro. After recording this macro, I noticed that...

If I have a range from d5:z5, and column "D" has various text references and numbers. I want to format the rows, in column "D", that have the word "Price" as currency, and format the rest as comma without decimal places. Does anybody know how to do this. dyana

Let's say that I have a range from a1:z30, and I want to protect cells based on the following criteria. (1) everything should be protected except for items specified in (2) (2) Rows that have "Forecast" in column "H" should only be protected through a certain column number...

I tried to download a text file into Excel and I had a problem. There are rows that have a "*" in front of the row data of the text file. The rows that have the "*" are not able to be parsed upon opening the file in Excel. This results in my not importing many rows of data...

I recorded a macro in Excel to create a button, that when involked would run a series of other macro. Unfortunately when I tried to run this recorded macro it would not work. When recording this macro, I renamed the button from "button 1" to "Execute Process". Yet I...

How do you write a VBA code that highlights an entire data range within Excel and names it "datarange"? I need this code to basically start at column "G" through "AF" and move to the bottom of the database. The database size could vary, meaning it will occupy...

Hello, I would like to know how to set up a macro that could automatically code code cells if a certain condition was met. If I have downloaded some information into excel and say column "D" shows a two-digit code, with the second number indicating the month i.e. 22 would mean...