Try This Code
Sub VlookupByCodes()
Dim ResultRange As Range
Dim SearchRange As Range
Dim ColNum As Integer
Dim LookUpValue As Range
Dim cellResult As Range
Dim CellSearch As Range
Dim i As Integer
Set ResultRange = Application.InputBox("Select the Range Where You
want Output"
Hi Pascal
Try:
Private Sub CommandButton1_Click()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Columns("A:A").Hidden = Not ws.Columns("A:A").Hidden
Next
End Sub
Thanks
Mahesh
On Sat, Jul 16, 2011 at 11:11 PM, bpascal123 wrote:
> Hi,
>
> I would like to know if there is a way to use the same
Hi,
I would like to know if there is a way to use the same code for an
activeX toggle button present one time on all sheets in a workbook.
For instance, when the toggle button is toggled, it should hide some
columns and when "untoggled" it should show the hidden columns. Column
numbers are the sa
I have a table where I maintain a log of every contact event I make with my
customers. In a Pivot table, I'm trying to return and calculate the first
contact event made by unique ID. When I pivot by ID and dump in "Log
Contact", it sums up all the contacts. If I use the Max function, then it
doe
I have a table where I maintain a log of every contact event I make
with my customers. In a Pivot table, I'm trying to return and
calculate the first contact event made by unique ID. When I pivot by
ID and dump in "Log Contact", it sums up all the contacts. If I use
the Max function, then it doe
Thanks a lot
On Fri, Jul 15, 2011 at 9:44 PM, STDEV(i) wrote:
> *1.
> **Worksheet.Change Event*
> *
> *Occurs when cells on the worksheet are changed by the user or by an
> external link.
> This event doesn't occur when cells change during a recalculation. Use the
> Calculate event to trap a she
Try this
Sub PasteIt()
Sheets("Heading").Activate
Rows("5:6").Copy
For i = ActiveSheet.Index To Sheets.Count
ActiveSheet.Next.Activate
Range("A5").Select
ActiveSheet.Paste
If ActiveSheet.Index = Sheets.Count Then Exit Sub
Next
End Sub
From: excel-macros@googlegroups.com [mailto:
