| Recent Answers from Adelaide carvalho |
 |
2008-11-30 vba solution: Hi Vimal How are you? Please have a look at Sub deleteduplicates() Dim R As Range, I As Integer, J As Integer, RT As Range Set R = ActiveSheet.Range("a1:j50") J = 1 For I = 1 To R.Rows.Count...
|
2008-11-21 "UnMerge" Titles: Hi Bob How are you? To unmerge the headings, just do this Sub unmergetitles() Range("A6:F6").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment =...
|
2008-11-20 Return all occurrences: Hi Pat How are you? Please do the following if you have Excel 2003 0. Write your data (line and vehicles) in A3:D10 1. Write Car in S1 2. Tools-macro-visual basic editor 3. Insert-Module 4. copy...
|
2008-11-16 Return all occurrences: Hi Pat How are you? Please try the following example 1. Tools - macros-Visual Basic Editor 2. Insert module 3. Copy the following code Sub searchinglinesofproducts() Dim RP As Range, Searc As...
|
2008-11-13 filtering: Hi vahid How are you? How is the following code Sub FILTER_ABS() ' ' FILTER_ABS Macro ' FILTERING Dim s As Integer, y As Integer y = InputBox("Enter year", "Year selection") For s = 1 To...
|
| More Answers for "Excel" |