Remove Hyperlinks in Excel

October 4, 2009 by vba excel · 2 Comments
Filed under: Excel Tips 

Excel Tips Remove Hyperlinks in Excel [Q]

I need help on removing hyperlinks in excel, i’ve just downloaded information from an encyclopedia article for my class and want to eliminate the excel spreadshe..... Read The Solution..

Copy Entire Rows to Another Spreadsheet Based on Cell Criteria

September 29, 2009 by vba excel · 4 Comments
Filed under: Excel Spreadsheet, Excel Vba 

Excel Vba Copy Entire Rows to Another Spreadsheet Based on Cell Criteria [Q]

I am looking for excel vba codes to copy rows based on partial cell content. I have an excel spreadsheet called “main.xls” from which I w..... Read The Solution..

Streamlining Macro Created by Macros Recorder

September 27, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Streamlining Macro Created by Macros Recorder [Q]

I used the macro recorder in Excel to create a nice macro to reorganize some raw data into a format more useful for Excel to work with. In moving the data around, at..... Read The Solution..

Copying Cells Which Include Conditional Formatting in Worksheet

September 25, 2009 by vba excel · Leave a Comment
Filed under: Excel Worksheet 

Excel Worksheet Copying Cells Which Include Formatting in Worksheet [Q]

I need some help modifying this microsoft excel code to include the worksheet formatting of the cell (conditional formatting):

If Not Intersect(Tar..... Read The Solution..

How to Draw Lines on User Form

August 25, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips How to Draw Lines on User Form [Q]

I need help to draw lines in a microsoft excel User Form. How do I do this? Line is not an option in the Form Tool box. Or am I now seeing it? Thank you in advance for any help you..... Read The Solution..

« Previous PageNext Page »