Thank you Don for the help. Your input was very valuable and it fixed the
color shading on column "H"
I need to bother you again and send me a quick Sub to do the following:
Whenever there is a value on a cell located on column "H" (it could be a
value or a formula). I need a routine that can
.EntireRow.Delete
> End If
> Else
> Set rng = rng.Offset(-1, 0)
> rng.Offset(1, 0).EntireRow.Delete
> End If
> Else
> Set rng = rng.Offset(-1, 0)
> rng.Offset(1, 0).EntireRow.Delete
> End If
> Set rng
Thank you for the reply. While this works fine, it find it that it requires
a lot of copy and paste back and forth. I was looking for an answer that
would be more like creating a file in .txt format.
Some time ago I had a similar problem and the solution involve this code:
Filename = InputBox("
I have a simple table of banking transactions.
Columns are as follows
Column A = Date in MM/DD/YY format
Column B = Empty
Column C = Unit ID
Column D = Empty
Column E = Amount (numeric, 2 decimals)
Column F = Empty
Column G = Check No
Column H = Subtotal
On this sheet, the transactions are liste
I am trying to do a simple macro to look at a column or line (most of
the time a column) and evaluate the length on the data on each cell
and determine if it is 10 digits. If the value of the data in the
cell is different than 10 digits (more or less). I want that cell to
change color.
it is lik
I wrote a couple of weeks ago about converting Excel to .Txt and Mr.
Jeffries was very helpful in providing the solution. Now I have
another request. Using the same excel data as my previous example, I
need to create another .txt with a different variation.
this is what I have.
1 excel sheet
t;
> Tom
>
> On Wed, Apr 1, 2009 at 4:43 PM, Cesar Delanoval wrote:
>
>>
>> I need to know if anyone can help with write a macro or script that
>> will convert an Excel file to a .txt file after changing some of the
>> formats on the data.
>>
>> this
I need to know if anyone can help with write a macro or script that
will convert an Excel file to a .txt file after changing some of the
formats on the data.
this is what I have.
1 excel sheet with rows (they could vary) and 5 columns.
The columns do not have headings.
Column 1 = 13 digit field
