$$Excel-Macros$$ Excel commands to Electronic user interface.

[Cab Boose]

Hi

Looking for vba requirements for exporting commands  (on, off, etc) to a
relay board  for control of led lights etc.

Can someone send me in the right direction etc.  Do I need an add-in or
activate some controls.  Using 2000 at the moment but shortly onto Excel
2013.

Thankyou



Charles Harris

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Data Logging

[Cab Boose]

Hi

There are a lot of commercial software based around Excel for live logging
of incoming data from instruments etc.

Where can I find a site that covers the vba required for receiving data.
Say direct from data recorders and/or thru SMS and a website.  That is a
temperature is sent by SMS from a phone or equivalent device to a webpage
and then on into the Excel workbook or whatever procedure is best to get
data from a remote location (with phone coverage) to the office.

Thanks

Charles Harris

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ SMS messages into Excel

[Cab Boose]

Hi

Have found plenty of programs to send emails/sms from Excel.  I need
however something that will receive sms messages and then I will combine
with the map options to show positions and locations etc.   Looks probably
like Power View Intereactive Maps.  Any comments on that would also be
appreciated.

There will be something like 300+ locations that will sms data once a day
to base control pc/tablet.  The sending sms devices  will be self contained
and powered etc. These senders up to 500 kms away.

Just a suitable sms receiving data into Excel software or vba to do so.
 Will come off the internet.  Will have to do some testing etc then and
find out any limitations.

Manipulation of the data no problem.

Thankyou

Charles Harris

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel On Line with VBA

[Cab Boose]

Hi

Microsoft 2013 version available online with VBA editing (see
http://blogs.office.com/2014/04/14/weve-updated-excel-online-whats-new-in-april-2014/

but you cannot create a macro online.  Like fully use the online version
without requiring own excel on pc.

Is there anywhere with full online ?

Thnks
Charlie

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 updates in 7 topics

[Cab Boose]

Hi
Having a problem with Google Groups.  Using Chrome Win7

To send a new message it comes up with email to, Subject heading, tags to
enter,  but there is no  message block! to type in a message. Is there
something I am missing !
Charles Harris


On Mon, Jun 16, 2014 at 11:23 AM,  wrote:

>   Today's topic summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Event for dynamically add control in Excel VBA
><#146a1d7cb356a198_group_thread_0> [1 Update]
>- Data Fetching <#146a1d7cb356a198_group_thread_1> [1 Update]
>- Date Format Query <#146a1d7cb356a198_group_thread_2> [3 Updates]
>- plz add me to the group thanks <#146a1d7cb356a198_group_thread_3> [1
>Update]
>- how to crack Excel VBA password <#146a1d7cb356a198_group_thread_4>
>[1 Update]
>- Need help with making a macro revolving around finding certain
>numbers from a list <#146a1d7cb356a198_group_thread_5> [4 Updates]
>- Here is a Great Challenge - Retrieve data in from a multiple urls in
>one step <#146a1d7cb356a198_group_thread_6> [1 Update]
>
>   Event for dynamically add control in Excel VBA
> 
>
>"Ondřej Říha"  Jun 15 02:06PM -0700
>
>Hello,
>I would like to add sub for click event of dynamically add control
>button
>in user form for example in VBA for Excel. I found some examples on
>Internet but every finished with some error or didn't work.
>When I use for example this way:
>
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 1,
>"Private Sub CommandButton3_Click()"
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 2,
>"MsgBox ""Message here !"""
>Application.VBE.CodePanes(1).CodeModule.InsertLines NumLines + 3, "End
>Sub"
>
>for add new code at the end of code this code is added fine but work
>only
>after restart user form.
>Please can anybody make easy example to explain me how work adding
>controls
>to existing form with event for this control?
>Thank you very much Ondra
>
>
>
>   Data Fetching
> 
>
>Jocky Beta  Jun 15 11:27PM +0530
>
>Hi Team,
>
>I want to fetch data from one sheet to another sheet by referring the
>data,
>Attached sheet will explain you what i want exactly.
>
>Request all of you to kindly help me on this
>
>Regards
>
>
>
>   Date Format Query
> 
>
>GENIUS  Jun 14 10:36PM -0700
>
>look at the result
>
>
>
>
>Vaibhav Joshi  Jun 15 06:23PM +0530
>
>Hi
>
>You can change display format by going to cell property & select
>custom and
>type dd.mm.
>
>If by doing so if date format does not change then select single column
>then press Data tab in Menu then press Next 2 times then select Date
>(DMY)
>and press finish button.
>
>Cheers!!
>
>
>
>
>
>
>DELIN FRANCIS  Jun 16 01:24AM +0800
>
>Hi Pravin ...
>
>
>You can go to Format cell and custom the format of the date which ever
>result you need. furthermore you can see in the attachement.
>
>
>
>
>
>Delin.F
>
>
>
>
>On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi  wrote:
>
>
>
>Hi
>
>You can change display format by going to cell property & select
>custom and type dd.mm.
>
>If by doing so if date format does not change then select single
>column then press Data tab in Menu then press Next 2 times then select Date
>(DMY) and press finish button.
>
>Cheers!!
>
>
>
>On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal 
>wrote:
>
>Hi,
>
>>Kindly help.
>
>>Regards
>>Pravin Gunjal.
>--
>>To post to this group, send email to excel-macros@googlegroups.com.
>>Visit this group at http://groups.google.com/group/excel-macros.
>>For more options, visit https://groups.google.com/d/optout.
>
>--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like
>Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>Advice will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.

$$Excel-Macros$$ Excel to Import from SmartSheet

[Cab Boose]

I want to use an Excel workbook with 2 or 3 sheets with different small
databases.

One of the databases is to come from the web,  from a SmartSheet
spreadsheet.

Once the data into the .xls sheet I will run a macro to run a  report using
vlookup etc

To run the report I want a one button press to bring in the SmartSheet data
and to run the report.
I prefer not to open Smartsheet and export to a .xls sheet.  The users will
be in the .xls and will be required just to run the 1 macro.

Have used this code

http://social.msdn.microsoft.com/Forums/office/en-US/efdd909d-f564-4bb5-9e72-db0346e5f82f/excel-vba-import-worksheet-from-url?forum=exceldevhttp://social.msdn.microsoft.com/Forums/office/en-US/efdd909d-f564-4bb5-9e72-db0346e5f82f/excel-vba-import-worksheet-from-url?forum=exceldev>

but as the SmartSheet is not in .xls format, it creates the sheet ok, but
with no data.

Have tried using  'New Web Query'  to import into .xls sheet.   It runs
and I get a message (in .xls format) that the SmartSheet is too slow in
loading up.


Is there any other way of doing this ?   With option one above - once the
webpage is open get Excel to open the 'Sheet Actions' then 'Export' and
then import the .xls sheet that has been provided?

Your comments and ideas appreciated.

Again, I only want the user to have to click one button only to import and
repair report.  Do not want user having to go into Smartsheet and export
the report.


Thanks


Charlie Harris

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ VBA for Dynamic Range

[Cab Boose]

Hi

Have this macro to take the
See code below.  Comes up with compile error on the last row:
ActiveWorkbook..

Is it something to do in not having the sheet name ? If so it would have to
be taken from the tab. (I now see it is referenced as sht.)

or  Is it something to do with the R1C1 references. I have not used the
R1C1 reference before, but it appears to be ok.

Any comments? Thanks
Charlie Harris
Sub DynamicNames_MultiCol()

  Dim ColCount As Long
  Dim LabelRow As Long
  Dim Col As Long
  Dim sName As String
  Dim c As Range
  Dim Sht As String

  'assign row and column parameters
  '**adjust for the row containing your headings
  LabelRow = 1
  ColCount = Selection.Columns.Count

  'grab sheet name
  Sht = "'" & ActiveSheet.Name & "'"

   Col = ActiveCell.Column
sName = ActiveCell.Value
If Len(sName) > 1 Then
  'replace spaces with underscores
  sName = Replace(sName, " ", "_", 1)
  'create the name
  ActiveWorkbook.Names.Add Name:=sName, RefersToR1C1:= _
"=OFFSET(" & Sht & "!R2C" & Col & ",0,0,COUNTA(" & Sht & "!C" & Col
& ")-1," & ColCount & ")"
End If
End Sub

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Xl2000 and HID device using =myserver function

[Cab Boose]

Hi

I think I may need some macros here as well.

On this url there is a description of using HID devices in XL.

http://www.aggsoft.com/usb-hid-logger/tutorials/usb-hid-to-excel.htm

The description is:


"Excel has built-in tools for getting USB HID data. All you have to do is
specify the formula like this for a cell:

=myserver|mytopic!myUSB HIDitem

where:

myserver - USB HID server name;

mytopic - topic name;

myUSB HIDitem - USB HID report items name.

Once the item is updated on the server, it will be automatically updated in
Excel"

 **



I have not come across the  'myserver' and 'mytopic' before and would like
to know where I can find an example workbook similiar and demonstrates how
it works.

It seems it could ne also known as RTD Real Time Data.



What I am trying to do is to have 2 or more usb  rfid  HID based readers
going into different columns in same worksheet.  I think I will have to add
another library etc.



Would be greatful if you can guide me towards some info.



Regards and thanks



Charlie Harris

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

[Cab Boose]

Thnkyou Guys for the codes.

The code that Anoop sen t works very well, and I will go with that. Thanks
for your help Lalit and Anoop

Regards

Charlie

On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma wrote:

> Please try the below one.
>
> Sub PasteValueOnly()
> Dim rng As Range
> Set rng = Sheets("DailyList").Range("ItemsList")
> rng.Copy
> Sheets("ItemsListArchives").Range("D1").PasteSpecial xlPasteValues
>  End Sub
>
>
> On Mon, Dec 31, 2012 at 12:01 PM, Lalit Mohan Pandey <
> mohan.pande...@gmail.com> wrote:
>
>> Dear Charlie,
>>
>> Please share your file with us if it is confidential then please share
>> sample at least for better clearity.
>>
>> Regards,
>> Lalit Mohan
>>
>>
>> On Monday, 31 December 2012 11:46:32 UTC+5:30, sswcharlie wrote:
>>
>>> Hi Lalit
>>>
>>> Have tried the code , same result.  Getting the  'application defined
>>> or object defined error' message.  Can you review for me.  A mystery to
>>> solve.
>>> Thnaks
>>>
>>>
>>> Charlie
>>>
>>>
>>> On Mon, Dec 31, 2012 at 4:11 PM, Lalit Mohan Pandey <
>>> mohan.p...@gmail.com> wrote:
>>>
 Hi Charlie,

 You can copy only value from source to destination using below code
 also:


 Sub TestCopyValues()

 Dim varArray()As Variant

 varArray = Sheets("DailyList").Range("**ItemsList").Value
 Sheets("ItemsListArchives").**Range("D").Resize(UBound(**varArray),
 UBound(varArray, 2)).Value = varArray

 Erase varArray

 End Sub

 Hope this will help you.


 Regards,
 Lalit Mohan


 On Monday, 31 December 2012 08:19:44 UTC+5:30, sswcharlie wrote:
>
>
>
> Hi Ashish
>
> Thanks for code.  Still not working.  Has message to say   'application
> defined or object defined error'.  Using XL2000
>
> Note that my code without the .value works fine and copies across
> except it has the  error   messages.  Just need to addthe value only.
>
> Thnaks
>
> Charlie
>
>
>
>
>
> On Sunday, December 30, 2012 8:45:51 PM UTC+13, sswcharlie wrote:
>
>> Hi
>>  I want to copy the values only to another sheet. Without .value on
>> the end it copies thru with error messages. If I put . value on the end 
>> it
>> comes up with message 'copy method of range class failed'. Do not want to
>> use copy/paste special method. Want to use 'Destination" as shown.
>>   
>>  Sheets("DailyList").Range("**Ite**msList").Copy
>> Destination:=Sheets("**ItemsList**Archives").Range("D" &
>> Rows.Count).End(xlUp).Offset(**7**).value
>> 
>>  Found other code on the net that just used the .value but one above
>> it does not work. Do I have to make a small change ? or does the .value 
>> go
>> in a different position ?
>>   Thanks
>>  Charlie Harris
>>
>  --
 Join official Facebook page of this forum @ https://www.facebook.com/**
 discussexcel 

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@**
 googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/excel-macros?hl=en
 .



>>>
>>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message becau

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

[Cab Boose]

Hi Lalit

Have tried the code , same result.  Getting the  'application defined or
object defined error' message.  Can you review for me.  A mystery to solve.
Thnaks


Charlie


On Mon, Dec 31, 2012 at 4:11 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:

> Hi Charlie,
>
> You can copy only value from source to destination using below code also:
>
>
> Sub TestCopyValues()
>
> Dim varArray()As Variant
>
> varArray = Sheets("DailyList").Range("ItemsList").Value
> Sheets("ItemsListArchives").Range("D").Resize(UBound(varArray),
> UBound(varArray, 2)).Value = varArray
>
> Erase varArray
>
> End Sub
>
> Hope this will help you.
>
>
> Regards,
> Lalit Mohan
>
>
> On Monday, 31 December 2012 08:19:44 UTC+5:30, sswcharlie wrote:
>>
>>
>>
>> Hi Ashish
>>
>> Thanks for code.  Still not working.  Has message to say   'application
>> defined or object defined error'.  Using XL2000
>>
>> Note that my code without the .value works fine and copies across except
>> it has the  error   messages.  Just need to addthe value only.
>>
>> Thnaks
>>
>> Charlie
>>
>>
>>
>>
>>
>> On Sunday, December 30, 2012 8:45:51 PM UTC+13, sswcharlie wrote:
>>
>>> Hi
>>>  I want to copy the values only to another sheet. Without .value on the
>>> end it copies thru with error messages. If I put . value on the end it
>>> comes up with message 'copy method of range class failed'. Do not want to
>>> use copy/paste special method. Want to use 'Destination" as shown.
>>>   
>>>  Sheets("DailyList").Range("**ItemsList").Copy 
>>> Destination:=Sheets("**ItemsListArchives").Range("D"
>>> & Rows.Count).End(xlUp).Offset(**7).value
>>> 
>>>  Found other code on the net that just used the .value but one above it
>>> does not work. Do I have to make a small change ? or does the .value go in
>>> a different position ?
>>>   Thanks
>>>  Charlie Harris
>>>
>>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ VBA to Destination of Value only

[Cab Boose]

Hi
 I want to copy the values only to another sheet. Without .value on the end
it copies thru with error messages. If I put . value on the end it comes up
with message 'copy method of range class failed'. Do not want to use
copy/paste special method. Want to use 'Destination" as shown.
  
 Sheets("DailyList").Range("ItemsList").Copy
Destination:=Sheets("ItemsListArchives").Range("D" &
Rows.Count).End(xlUp).Offset(7).value

 Found other code on the net that just used the .value but one above it
does not work. Do I have to make a small change ? or does the .value go in
a different position ?
  Thanks
 Charlie Harris

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Deleteing Rows based on single column contents

[Cab Boose]

Hi Don and Asa

Yes I have just found your code.  The asterix code works well.  Now between
the different options I can achieve what I need. Magic.

Thanks and regards to you both.

Charlie Harris

On Sat, Apr 7, 2012 at 10:54 AM, Asa Rossoff  wrote:

> Charlie,
>
> Did you see the solution I posted for you?
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Friday, April 06, 2012 3:53 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Deleteing Rows based on single column
> contents
>
> ** **
>
> Hi Don
>
>  
>
> Half way there.  All the options I use with spaces etc work very well. The
> one stumbling block is to delete the rows with   *
>
> It works but deletes all rows except the header.
>
>  
>
>  
>
> I see the text to find is normally inside of the two  asterix like
> *setouts*  ,  but if I do with** it just deletes all rows.
>
>  
>
> There a 70 * in the cell
> **
> 
>
>  
>
> Your comments would be appreciated.
>
>  
>
> Thanks
>
>  
>
> Charlie Harris
>
>
>
>  
>
> On Sat, Apr 7, 2012 at 1:02 AM, dguillett1  wrote:**
> **
>
> Try either of these. If you want more than one incorporate AND
>
>  
>
> Sub DeleteFilteredRowsSAS()
>
>   With Range("B5:B" & Cells(Rows.Count, 2).End(xlUp).Row)
>
>.AutoFilter field:=1, Criteria1:="*SETOUTS*"
>
>.Offset(1).SpecialCells(xlVisible).EntireRow.Delete
>
>' MsgBox "hi"
>
>.AutoFilter
>
> End With
>
> End Sub
>
>  
>
> Sub delrowsSAS()
>
> Dim i As Long
>
> For i = Cells(Rows.Count, 2).End(xlUp).Row To 5 Step -1
>
> If InStr(Cells(i, 2), "SETOUTS") > 0 Then MsgBox i 'Rows(i).Delete
>
> Next i
>
> End Sub
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Cab Boose  
>
> *Sent:* Friday, April 06, 2012 3:06 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Deleteing Rows based on single column contents
> 
>
>  
>
> Hi
>
>  
>
> In worbook attached I am deleting rows based on contents of column C.
>
>  
>
> When I use as it is set up at the moment it works as it should and deletes
> rows withSETOUTS   in them.  That is good.
>
>  
>
> However, in a second similiar macro,  I also want to delete rows that have
> in column C this :***but as it is a wildcard
> character I am having difficulty to get it to work.  Usually deletes most
> of the sheet.  How do I tell in the macro that the last asterix is the wild
> card and that previous asterix are what is in the cell ? and that is a row
> to delete.
>
>  
>
> A similiar thing is there are a lot of rows that have 6 spaces and then
> some text, text varies and unknown.  I have tried putting in   6 spaces and
> *  (  *)  or  (*  ) like that but to know available.  how do you
> allow for spaces preceding unknown text ?
>
>  
>
> A model railroad project.
>
>  
>
> Thanks and regards
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Deleteing Rows based on single column contents

[Cab Boose]

Hi Don

Half way there.  All the options I use with spaces etc work very well. The
one stumbling block is to delete the rows with   *
It works but deletes all rows except the header.


I see the text to find is normally inside of the two  asterix like
*setouts*  ,  but if I do with** it just deletes all rows.

There a 70 * in the cell
**

Your comments would be appreciated.

Thanks

Charlie Harris



On Sat, Apr 7, 2012 at 1:02 AM, dguillett1  wrote:

>   Try either of these. If you want more than one incorporate AND
>
> Sub DeleteFilteredRowsSAS()
>   With Range("B5:B" & Cells(Rows.Count, 2).End(xlUp).Row)
>.AutoFilter field:=1, Criteria1:="*SETOUTS*"
>.Offset(1).SpecialCells(xlVisible).EntireRow.Delete
>' MsgBox "hi"
>.AutoFilter
> End With
> End Sub
>
> Sub delrowsSAS()
> Dim i As Long
> For i = Cells(Rows.Count, 2).End(xlUp).Row To 5 Step -1
> If InStr(Cells(i, 2), "SETOUTS") > 0 Then MsgBox i 'Rows(i).Delete
> Next i
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Friday, April 06, 2012 3:06 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Deleteing Rows based on single column contents
>
>  Hi
>
> In worbook attached I am deleting rows based on contents of column C.
>
> When I use as it is set up at the moment it works as it should and deletes
> rows withSETOUTS   in them.  That is good.
>
> However, in a second similiar macro,  I also want to delete rows that have
> in column C this :***but as it is a wildcard
> character I am having difficulty to get it to work.  Usually deletes most
> of the sheet.  How do I tell in the macro that the last asterix is the wild
> card and that previous asterix are what is in the cell ? and that is a row
> to delete.
>
> A similiar thing is there are a lot of rows that have 6 spaces and then
> some text, text varies and unknown.  I have tried putting in   6 spaces and
> *  (  *)  or  (*  ) like that but to know available.  how do you
> allow for spaces preceding unknown text ?
>
> A model railroad project.
>
> Thanks and regards
>
> Charlie
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Turn Tab Order on/off

[Cab Boose]

Hi Asa and Don

Thanks for all your comments and help.

Now I see what it is doing, as you explained in your emails. Yes it does
work, in quite a different way to what I was expecting.  My apologies for
being so dumb.

With this sheet it is normally filled in once and not all of the tabbed
cells will be used.   I need to be able to keep tab/enter until the cell is
reached that needs to have an entry and then on to the next cell that has
an entry.  To be able to make changes in cells other than the tabbed cells
I need to be able to unlock the tab sequence make the change and then lock
again so that the tab sequence is being used again.  This will not happen
very often.  Mostly in tab mode.

Yes I am using Excel2000.  Going to upgrade sometime soon.

It appears then that I have not got the right vba code to switch the tab
code on and off, and that when tab order locked in that it only goes to the
tab order codes.

Hope I have explained clear enough.

Thanks and regards

Charlie Harris

On Sun, Mar 25, 2012 at 3:11 AM, Asa Rossoff  wrote:

> Yeah, I realize -- he's on 2000.  Nothing jumped out at me in the
> macro/workbook he's discussing that obviously relied on any new features.
> I can't claim to be the ultimate version expert though.
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *dguillett1
> *Sent:* Saturday, March 24, 2012 7:07 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Turn Tab Order on/off
>
> ** **
>
> I haven’t followed this but I think Charlie has a older version ( if that
> makes a difference) ??
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Asa Rossoff  
>
> *Sent:* Saturday, March 24, 2012 2:27 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* RE: $$Excel-Macros$$ Turn Tab Order on/off
>
>  
>
> Hi Charlie, Good day -
>
> I'm not sure what the trouble is.
>
>  
>
> Works in Excel 2010.
>
>  
>
> Just to reiterate, the macro does not make the tab key go from field to
> field.  It only has effect when a field (listed cell) is edited.  What the
> macro does: after you've edited a cell in the list, it selects the next
> cell in the list.  If you don't edit a cell, the macro does nothing, and
> you can tab all over the place.
>
>  
>
> to troubleshoot the macro, you can go in the VBE/macro editor (Alt-F11)
> and set a breakpoint on a line in the macro.  To set a breakpoint, you can
> hit F9 on a line.  Then the macro will stop on that line (if the macro runs
> at all).  If it doesn't run, then that would explain why it doesn't do
> anything and we can try to figure out why.  If it does run, the macro
> editor will pop up on the screen with the macro running but paused.  You
> can then hit F8 to execute one line at a time (or Debug menu -> Step Into
> for the same).  See if you can figure out where the marco is failing you.*
> ***
>
>  
>
> Give it a shot, and post back.  I can try to help you debug it if you need
> more help.  It's kind of hard to do by email like this, though.
>
>  
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Cab Boose
> *Sent:* Saturday, March 17, 2012 2:47 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Turn Tab Order on/off
>
>  
>
> Good Day Asa
>
>  
>
> Are you able to assist with this for me.  Would be greatly appreciately.**
> **
>
> Thanks
>
> Charlie
>
> On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose  wrote:
>
> Hi Asa
>
> At the moment the H1 setting makes no difference. The sheet works like
> normal with the setting at activate or deactivate, and not in tab order.**
> **
>
> Thanks
>
> Charlie
>
>  
>
> On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff  wrote:***
> *
>
> Hi Charlie,
>
> The "button" is actually just a cell that is colored.  It has Data
> Validation enabled for that cell that restricts values to "Activate" and
> "Deactivate".
>
>  
>
> The "tab order" macro seems to be pretty straightforward and I would
> expect it to work with Excel 2000, but I am not an expert at what is and is
> not supported.
>
>  
>
> The macro moves the selection to the next data entry cell only when a cell
> is edited.  *Not* particularly when tab is pressed.
>
>  

Re: $$Excel-Macros$$ Turn Tab Order on/off

[Cab Boose]

Good Day Asa

Are you able to assist with this for me.  Would be greatly appreciately.
Thanks
Charlie

On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose  wrote:

> Hi Asa
>  At the moment the H1 setting makes no difference. The sheet works like
> normal with the setting at activate or deactivate, and not in tab order.
>  Thanks
>   Charlie
>
>
> On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff  wrote:
>
>> Hi Charlie,
>>
>> The "button" is actually just a cell that is colored.  It has Data
>> Validation enabled for that cell that restricts values to "Activate" and
>> "Deactivate".
>>
>> ** **
>>
>> The "tab order" macro seems to be pretty straightforward and I would
>> expect it to work with Excel 2000, but I am not an expert at what is and is
>> not supported.
>>
>> ** **
>>
>> The macro moves the selection to the next data entry cell only when a
>> cell is edited.  *Not* particularly when tab is pressed.
>>
>> ** **
>>
>> Can you confirm that when cell "H1" says "Activate" and you edit one of
>> the cells listed at the end of this sentence and hit either tab or enter to
>> leave the cell that the selection does not go to the next cell in this
>> list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26,
>> n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84,
>> e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88,
>> j88, e89, f89, h89, j89?
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
>> *Sent:* Saturday, March 03, 2012 10:07 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Turn Tab Order on/off
>>
>> ** **
>>
>> HI
>>
>>  
>>
>> In attached workbook Ashish has produced a great macro but he is not use
>> to XL2000, only later ones.
>>
>>  
>>
>> There is a button at top of worksheet to turn on/off the macro that sets
>> the tab order.  Not working currently, is there an adjustment to make for
>> XL2000 ?
>>
>> Once going, please check when in tab order mode that if a entry is
>> incorrect and user hits delete for that cell that it does not delete info
>> in all tabbed cells.
>>
>>  
>>
>> Your assistance appreciated.
>>
>>  
>>
>> Charlie
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ memb

Re: $$Excel-Macros$$ Turn Tab Order on/off

[Cab Boose]

Hi Asa
 At the moment the H1 setting makes no difference. The sheet works like
normal with the setting at activate or deactivate, and not in tab order.
 Thanks
  Charlie


On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff  wrote:

> Hi Charlie,
>
> The "button" is actually just a cell that is colored.  It has Data
> Validation enabled for that cell that restricts values to "Activate" and
> "Deactivate".
>
> ** **
>
> The "tab order" macro seems to be pretty straightforward and I would
> expect it to work with Excel 2000, but I am not an expert at what is and is
> not supported.
>
> ** **
>
> The macro moves the selection to the next data entry cell only when a cell
> is edited.  *Not* particularly when tab is pressed.
>
> ** **
>
> Can you confirm that when cell "H1" says "Activate" and you edit one of
> the cells listed at the end of this sentence and hit either tab or enter to
> leave the cell that the selection does not go to the next cell in this
> list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26,
> n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84,
> e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88,
> j88, e89, f89, h89, j89?****
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, March 03, 2012 10:07 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Turn Tab Order on/off
>
> ** **
>
> HI
>
>  
>
> In attached workbook Ashish has produced a great macro but he is not use
> to XL2000, only later ones.
>
>  
>
> There is a button at top of worksheet to turn on/off the macro that sets
> the tab order.  Not working currently, is there an adjustment to make for
> XL2000 ?
>
> Once going, please check when in tab order mode that if a entry is
> incorrect and user hits delete for that cell that it does not delete info
> in all tabbed cells.
>
>  
>
> Your assistance appreciated.
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excude some sheets in macro

[Cab Boose]

Hi

See attachedI workbook. XL2000

Refer to summary sheet

I am wanting to extract data from some sheets into summary sheet.  I can
exclude 1 sheet ok, but when I try to exclude others I get syntax error.

The line of code with problem is:

If Worksheets(k).Name = "summary", "forms", "admin" Then GoTo nextk

I do not want to copy cells in   summary, forms, or admin.  Something to do
with the commas, have tried also without the commas.

Should I clear the summary sheet each time before paste or delete sheet and
make a new one called summary?

Thanks and regards

Charlie Harris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


ExclSheetsVBA.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ inventory sheet

[Cab Boose]

Hi

I have  opened the file for webandmacros workbook posted here.  The first
sheet for stock management is blank. No buttons/forms etc. The other sheets
are ok and show the information.

If I go to VBA to check the code for the VBA Project it asks for a
password, which I do not know. Shoulod I need to have the password.

Thanks

Charlie





On Sun, Feb 26, 2012 at 7:00 PM, raghu gr  wrote:

> sir,
>
> Thank you, its good one.
>
> with regards
> raghu
>
>
> On Sun, Feb 26, 2012 at 12:56 AM, Maries  wrote:
>
>> Hi,
>>
>> Check this link,
>>
>> http://www.webandmacros.com/macro_excel_gestion_stocks.htm
>>
>> Regards,
>>
>> MARIES.
>> On Sat, Feb 25, 2012 at 7:27 PM, xlstime  wrote:
>>
>>> please fine the below link for excel inventory
>>>
>>> http://www.excelmagic.com/inventorymagic.html
>>>
>>>
>>> On Sat, Feb 25, 2012 at 7:31 PM, raghu gr wrote:
>>>


 Hi,

 How to maintain inventory in excel sheet, is there any excel sheet /
 template / macro.

 with regards
 raghu

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> .
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Adv

Re: $$Excel-Macros$$ Toolbar

[Cab Boose]

Hi Sam

Wow that worked in getting onto toolbar.

I would like to have several  'run macroxx' on the toolbar.  Each one a
different macro to run.  I would need an input box to give caption for each
entry on toolbar  and a listbox to select the macro from a list of
available macro (from Macro dialog)to attach to that caption.

eg  caption:  Run: Sort  which would  use  macro 'SortAscend'
eg  caption:  Run: Format which would use  macro "FormatSheet"

Sorry to trouble you and make more complicated.

Regards

Charlie






On Sat, Feb 25, 2012 at 11:24 PM, Sam Mathai Chacko wrote:

> Yes this can be done
>
> Just a quick scrap here with bare minimum requirements...
>
> Sub AddMacroToToolBar()
>
> Dim lngLoop As Long
> Const strMacroNames = "Macro,Delete"
>
> For lngLoop = 1 To 2
> With Application.CommandBars("Worksheet Menu
> Bar").Controls("&Tools")
> On Error Resume Next
> .Controls("Run " & Split(strMacroNames, ",")(lngLoop -
> 1)).Delete
> Err.Clear: On Error GoTo 0
> With .Controls.Add(Type:=msoControlButton, ID:=1)
> .Style = msoButtonIconAndCaption
> .Caption = "Run " & Split(strMacroNames, ",")(lngLoop - 1)
> .OnAction = Split(strMacroNames, ",")(lngLoop - 1)
> End With
> End With
> Next
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sat, Feb 25, 2012 at 6:44 AM, Cab Boose  wrote:
>
>> Hi
>>
>> Xl2000
>>
>> I want to add some macros to the existing'Tools'  toolbar.   Have
>> looked at several on the net.  JKP, Contextures, Vbax, etc.  They seem to
>> use mainly a floating toolbar.
>>
>> I just want to run a macro that says -  Add this macro (from a list
>> showing in current workbook) onto the 'Tools' toolbar, and maybe a 'Delete'
>> from tools toolbar.
>>
>> Anyone know of a suitable code online.
>>
>>
>> Thanks and regards
>>
>> Charlie Harris
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

[Cab Boose]

Hi

You need to  make the names of the macros in the call routine the same as
the name in the Tools/Macro list.  That is Fill1, Fill2 etc and not Macro1,
Macro2 etc




On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer  wrote:

> **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Toolbar

[Cab Boose]

Hi

Xl2000

I want to add some macros to the existing'Tools'  toolbar.   Have
looked at several on the net.  JKP, Contextures, Vbax, etc.  They seem to
use mainly a floating toolbar.

I just want to run a macro that says -  Add this macro (from a list showing
in current workbook) onto the 'Tools' toolbar, and maybe a 'Delete' from
tools toolbar.

Anyone know of a suitable code online.


Thanks and regards

Charlie Harris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Find & copy row into New sheet

[Cab Boose]

Hi Don


The code works great.  Just going thru how it does things.  Your help
appreciated.

Thanks


Charlie

On Fri, Feb 17, 2012 at 6:32 AM, dguillett1  wrote:

>   See attached
> Sub GetRequestedItemSheetSAS()
> what = InputBox("Enter item ie: bolt")
> Sheets.Add
> With ActiveSheet
> .Name = what
> '===
> With Sheets("List").Range("d9:G1000")
> .AutoFilter Field:=4, Criteria1:="=*" & what & "*", Operator:=xlAnd
> .Copy Sheets("bolt").Range("A1")
> .AutoFilter
> End With
> '===
> .Columns.AutoFit
> End With
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Tuesday, February 14, 2012 11:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Find & copy row into New sheet
>
>
> Hi and Ooops.  File attached now
> Charlie
> On Wed, Feb 15, 2012 at 1:03 PM, Cab Boose  wrote:
>
>> Hi
>>  Excel 2000
>>  Attached workbook 'Sheet!List' tab. For standardising
>> descriptions,  (different users!)  I need to be able to extract a string
>> and copy /paste all instances into a new sheet, sheet to be named the
>> string of the search.  Full list 2000+ rows.
>>  eg If I am looking for 'Bolt' the  macro will find all instances and
>> copy  each row into new worksheet called 'Bolt'
>>  I can then review, change as required, and delete the sheet as an when
>> required.
>>  Code is:
>> Option Explicit
>> Sub Macro2()
>> '
>> ' Macro2 Macro
>> ' Macro recorded 14/02/2012 by Charlie
>> '
>>  '
>>   Columns("G:G").Select
>> Range("G9").Activate
>> Selection.FindNext(After:=ActiveCell).Activate
>> Range("D:").Select
>> Range("G14").Activate
>> Selection.Copy
>> Sheets.Add
>> Sheets("Sheet5").Select
>> Sheets("Sheet5").Name = "Bolt"
>> Range("F13").Select
>> ActiveSheet.Paste
>> Range("H17").Select
>> End Sub
>>
>>
>> Should I open the new sheet first? with the code to open new sheet with
>> the Find string as the name. eg /bolt
>>
>> Is it be better to use an Input Box than the Find Box ? I notice that the
>> original 'Find' does not appear in the code. Can I use an input box to
>> select the column to search, will always only be one column.
>>
>> I need help in the code to copy when instance found. Row.Copy ?  instead
>> of Selection.copy.  And put in Destination code
>>
>> Your comments would be appreciated.
>>
>> Thanks & regards
>> Charlie  68 next week & enjoy Excel
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

[Cab Boose]

Hi Noorain & Viper

The code Viper has posted works like magic.   Thanks guys.  I can now go to
sleep.


Charlie

On Thu, Feb 16, 2012 at 8:18 PM, The Viper  wrote:

> try this
>
> Sub GetColumnRef()
> Dim mSht
> mSht = ActiveSheet.Name
> Dim MyInput
> MyInput = InputBox("Enter Column to Search eg D:5")
> Sheets.Add.Name = MyInput
> Sheets(mSht).Activate
> End Sub
>
>
>
> On Thu, Feb 16, 2012 at 12:09 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Cab,
>>
>> Please try it..
>>
>> Sub GetColumnRef()
>> Dim CurrentIndex As Long
>> Dim MyInput
>> MyInput = InputBox("Enter Column to Search eg D5")
>> CurrentIndex = ActiveSheet.Index
>> If CurrentIndex > 1 Then
>>     Sheets(CurrentIndex - 1).Activate
>> Range(MyInput).Select
>> End If
>> End Sub
>>
>>
>>
>> On Thu, Feb 16, 2012 at 11:41 AM, Cab Boose  wrote:
>>
>>> HI
>>>
>>> Have this code:
>>>
>>> Sub GetColumnRef()
>>>
>>> Dim MyInput
>>>  MyInput = InputBox("Enter Column to Search eg D:5")
>>>
>>> Sheets.Add.Name = MyInput
>>>
>>> End Sub
>>>
>>> Works well, but leaves the active sheet as the new sheet. That is the
>>>  newly created sheet.
>>>
>>> How do I get it to return to the the sheet prevously used.  May not
>>> always be the same name ?
>>>
>>> Have tried   Sheet.Previous.Activate  and others and I am not getting it.
>>>
>>> Thanks
>>>
>>> Charlie
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Great day,*
> *viper*
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibite

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

[Cab Boose]

Hi Noorain

Thanks for the code.  I need to put athe code in again for the new
worksheet, have trieed some different places but still not working.  Your
comments would be appreciated.

Charlie

On Thu, Feb 16, 2012 at 7:39 PM, NOORAIN ANSARI wrote:

> Dear Cab,
>
> Please try it..
>
> Sub GetColumnRef()
> Dim CurrentIndex As Long
> Dim MyInput
> MyInput = InputBox("Enter Column to Search eg D5")
> CurrentIndex = ActiveSheet.Index
> If CurrentIndex > 1 Then
> Sheets(CurrentIndex - 1).Activate
> Range(MyInput).Select
> End If
> End Sub
>
>
>
> On Thu, Feb 16, 2012 at 11:41 AM, Cab Boose  wrote:
>
>> HI
>>
>> Have this code:
>>
>> Sub GetColumnRef()
>>
>> Dim MyInput
>> MyInput = InputBox("Enter Column to Search eg D:5")
>>
>> Sheets.Add.Name = MyInput
>>
>> End Sub
>>
>> Works well, but leaves the active sheet as the new sheet. That is the
>>  newly created sheet.
>>
>> How do I get it to return to the the sheet prevously used.  May not
>> always be the same name ?
>>
>> Have tried   Sheet.Previous.Activate  and others and I am not getting it.
>>
>> Thanks
>>
>> Charlie
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ VBA to return to Previous Sheet used

[Cab Boose]

HI

Have this code:

Sub GetColumnRef()

Dim MyInput
MyInput = InputBox("Enter Column to Search eg D:5")

Sheets.Add.Name = MyInput

End Sub

Works well, but leaves the active sheet as the new sheet. That is the
 newly created sheet.

How do I get it to return to the the sheet prevously used.  May not always
be the same name ?

Have tried   Sheet.Previous.Activate  and others and I am not getting it.

Thanks

Charlie

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Find & copy row into New sheet

[Cab Boose]

Hi
 Excel 2000
 Attached workbook 'Sheet!List' tab. For standardising descriptions,
(different users!)  I need to be able to extract a string and copy /paste
all instances into a new sheet, sheet to be named the string of the
search.  Full list 2000+ rows.
 eg If I am looking for 'Bolt' the  macro will find all instances and copy
each row into new worksheet called 'Bolt'
  I can then review, change as required, and delete the sheet as an when
required.
 Code is:
Option Explicit
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 14/02/2012 by Charlie
'
 '
  Columns("G:G").Select
Range("G9").Activate
Selection.FindNext(After:=ActiveCell).Activate
Range("D:").Select
Range("G14").Activate
Selection.Copy
Sheets.Add
Sheets("Sheet5").Select
Sheets("Sheet5").Name = "Bolt"
Range("F13").Select
ActiveSheet.Paste
Range("H17").Select
End Sub


Should I open the new sheet first? with the code to open new sheet with the
Find string as the name. eg /bolt

Is it be better to use an Input Box than the Find Box ? I notice that the
original 'Find' does not appear in the code. Can I use an input box to
select the column to search, will always only be one column.

I need help in the code to copy when instance found. Row.Copy ?  instead of
Selection.copy.  And put in Destination code

Your comments would be appreciated.

Thanks & regards
Charlie  68 next week & enjoy Excel

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Text Box - Properties

[Cab Boose]

Hi Asa and Sam

Thanks for all the info.  It will take me a couple of days to comprehend it
all and then I will get back to you.

I really appreciate your help

Regards

Charlie

On Tue, Feb 7, 2012 at 12:10 PM, Asa Rossoff  wrote:

> Hi Charlie,
>
> I don't have a lot of practicle experience in all areas of Excel, so I
> just realized there is an easier way to link controls to the worksheet!***
> *
>
> ** **
>
> Simply use the ControlSource property of the control and provide a cell
> reference or named range.  See
> http://www.ozgrid.com/Excel/free-training/ExcelVBA2/excelvba2lesson15.htm.
> 
>
> ** **
>
> The downside to this method (and also to the exact solution I provided
> below) is that the cell is updated immediately upon editing the value of
> the control.  Sometimes you want to wait until an entire form is completed
> to update data on the worksheet, in which case you will have to use some
> variation on the VBA method I described below. (And for posterity, like I
> said in a separate thread, you might want to use ThisWorkbook instead of
> the ActiveWorkbook that I used in Userform_Initialize if the linked cell
> will always be in the same workbook as the userform).
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff
> *Sent:* Saturday, February 04, 2012 5:38 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Text Box - Properties
>
> ** **
>
> The Active X Text Box control can be linked to a cell, but I think it is
> only available for use on a worksheet, not a userform… and everyone keeps
> telling me to avoid Active X controls on worksheets like the plague, anyway…
> 
>
> ** **
>
> To duplicate the linking behavior, you'll have to use a little VBA code.
> For example, in your form code you could use:
>
> Public TextBox1Cell As Range
>
> ** **
>
> Private Sub UserForm_Initialize()
>
> Set TextBox1Cell = ActiveWorkbook.Sheets("Sheet1").Range("A1")
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Terminate()
>
> Set TextBox1Cell = Nothing
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Activate()
>
> TextBox1.Value = TextBox1Cell.Value2
>
> End Sub
>
> ** **
>
> Private Sub TextBox1_Change()
>
> TextBox1Cell.Value2 = TextBox1.Value
>
> End Sub
>
> If you also need the control on the form to update if the worksheet cell
> is changed for some other reason while the form is still open (a
> calculation, other code,…) then you can add code to your worksheet's
> Calculate and Change events.  If the cell will only contain a value and not
> a formula, you don't need the calculate event.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> With UserForm1
>
> If .Visible Then
>
> If Not Application.Intersect(Target, .TextBox1Cell) Is Nothing
> Then
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> With UserForm1
>
>     If .Visible Then
>
> If .TextBox1.Value <> .TextBox1Cell.Value2 Then
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 4:27 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Text Box - Properties
>
> ** **
>
> Hi
>
>  
>
> I have a userform open with a 'text box' .  Want to link with a cell in
> sheet.
>
>  
>
> However the 'text box'  properties does not show a 'linked cell'
> heading. I am sure it use to.  How do I restore the missing property or
> is there another text box I should use.
>
>  
>
> Thks
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of

Re: $$Excel-Macros$$ vlookup in Text Box

[Cab Boose]

Hi Asa

Found the files see attached.

Charlie in New Zealand



On Mon, Feb 6, 2012 at 7:14 PM, Asa Rossoff  wrote:

> Charlie,
>
> Hmm… still not getting it.  Maybe an Excel 2010 incompatibility with your
> file?
>
> Can you right-click the userform and select Export File...  then send the
> resulting .frm and .frx files?
>
> Thanks,
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 9:10 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
> ** **
>
> Hi Asa
>
>  
>
> Workbook attached.  The code is in Userform 1.   Textbox 8
>
>  
>
>  
>
> Thanks 
>
>  
>
> Charlie
>
> On Mon, Feb 6, 2012 at 2:43 PM, Asa Rossoff  wrote:
>
> Hi Charlie,
>
> Can you post your workbook?  The original workbook you posted did not seem
> to contain your VBA project--just the data.
>
>  
>
> If I can see your form code I can better tell what might be going on.
>
>  
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 1:35 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi Asa
>
>  
>
> Have changed the two things, but now I get a 1004 error.   Unable to get
> the vlookup of the worksheet function class.  
>
>  
>
>  
>
> Note that I have Option Explicit at top of page, do I need to declare
> anything ?
>
> Thanks
>
>  
>
>  
>
> Charlie
>
> On Sun, Feb 5, 2012 at 8:20 PM, Asa Rossoff  wrote:
>
> Hi Charlie,
>
> Glad my last post helped :)
>
>  
>
> From a quick look I see two issues/potential issues:
>
> 1.   The syntax error:
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range.
> ("DBase"),2,False)
>
> *Remove the "." between "Range" and ("Dbase"):*
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range
> ("DBase"),2,False)
>
> 2.   The Defined Names (ranges) in your workbook.  They include the
> header row, which can interfere with lookup functions.  Not a high
> likelihood in the exact usage that you have here, but still might be a good
> idea to change.
>
>  
>
> P.S. In my last post, I used ActiveWorkbook.Worksheets(…).Range(…) in the
> Userform_Initialize event to set up the linked cell.  You can consider if
> ThisWorkbook is more appropriate than ActiveWorkbook in a given instance.
> I actually recommend always using ThisWorkbook if the workbook containing
> the VBA code/userform is the workbook you mean and only using
> ActiveWorkbook when you might mean another workbook---that which is
> on-screen at any given moment.  Avoid pitfalls that way.  Whoops :)
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 10:48 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi
>
>  
>
> See attached worksheet.   Excel2000
>
>  
>
> I have  userform1  and one of the codes is to lookup a part # (in Textbox
> 8)( say Part # 3 is to be entered here) in a named range called  DBase
> Once located to place the description in  textbox 5(named Description)
>
>  
>
> This is the code as per attached workbook,  have played around with the
> code but still not working.  Currently get a message for Syntax error.
>
>  
>
>  
>
>  
>
>  
>
> Private Sub TextBox8_Change()
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value,
> Range.("DBase"),2,False)
> End Sub
>
>  
>
> So if 3000 entered in Part # text box8  I would expect to get in Textbox 5
> the description:Print.Download-1/64...
>
>  
>
> Will have a 1000 + rows eventually. Will make the named range dynamic as
> well.
>
>  
>
> Not much code to check.  Your advice much appreciated.
>
> Thanks
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accur

Re: $$Excel-Macros$$ vlookup in Text Box

[Cab Boose]

Hi Asa

Have changed the two things, but now I get a 1004 error.   Unable to get
the vlookup of the worksheet function class.


Note that I have Option Explicit at top of page, do I need to declare
anything ?
Thanks


Charlie

On Sun, Feb 5, 2012 at 8:20 PM, Asa Rossoff  wrote:

> Hi Charlie,
>
> Glad my last post helped :)
>
> ** **
>
> From a quick look I see two issues/potential issues:
>
> **1.   **The syntax error:
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range.
> ("DBase"),2,False)
>
> *Remove the "." between "Range" and ("Dbase"):*
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range
> ("DBase"),2,False)
>
> **2.   **The Defined Names (ranges) in your workbook.  They include
> the header row, which can interfere with lookup functions.  Not a high
> likelihood in the exact usage that you have here, but still might be a good
> idea to change.
>
> ** **
>
> P.S. In my last post, I used ActiveWorkbook.Worksheets(…).Range(…) in the
> Userform_Initialize event to set up the linked cell.  You can consider if
> ThisWorkbook is more appropriate than ActiveWorkbook in a given instance.
> I actually recommend always using ThisWorkbook if the workbook containing
> the VBA code/userform is the workbook you mean and only using
> ActiveWorkbook when you might mean another workbook---that which is
> on-screen at any given moment.  Avoid pitfalls that way.  Whoops :)
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 10:48 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ vlookup in Text Box
>
> ** **
>
> Hi
>
>  
>
> See attached worksheet.   Excel2000
>
>  
>
> I have  userform1  and one of the codes is to lookup a part # (in Textbox
> 8)( say Part # 3 is to be entered here) in a named range called  DBase
> Once located to place the description in  textbox 5(named Description)
>
>  
>
> This is the code as per attached workbook,  have played around with the
> code but still not working.  Currently get a message for Syntax error.
>
>  
>
>  
>
>  
>
>  
>
> Private Sub TextBox8_Change()
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value,
> Range.("DBase"),2,False)
> End Sub
>
>  
>
> So if 3000 entered in Part # text box8  I would expect to get in Textbox 5
> the description:Print.Download-1/64...
>
>  
>
> Will have a 1000 + rows eventually. Will make the named range dynamic as
> well.
>
>  
>
> Not much code to check.  Your advice much appreciated.
>
> Thanks
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To pos

Re: $$Excel-Macros$$ Text Box - Properties

[Cab Boose]

Hi Asa

Thankyou very much for the code.  Magic.  Will be using the info you
provided. Will include in ;my library.

Another similiar question being posted shortly re vlookup in text box,
another little project.

Thanks

Charlie

On Sun, Feb 5, 2012 at 2:37 PM, Asa Rossoff  wrote:

> The Active X Text Box control can be linked to a cell, but I think it is
> only available for use on a worksheet, not a userform… and everyone keeps
> telling me to avoid Active X controls on worksheets like the plague, anyway…
> 
>
> ** **
>
> To duplicate the linking behavior, you'll have to use a little VBA code.
> For example, in your form code you could use:
>
> Public TextBox1Cell As Range
>
> ** **
>
> Private Sub UserForm_Initialize()
>
> Set TextBox1Cell = ActiveWorkbook.Sheets("Sheet1").Range("A1")
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Terminate()
>
> Set TextBox1Cell = Nothing
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Activate()
>
> TextBox1.Value = TextBox1Cell.Value2
>
> End Sub
>
> ** **
>
> Private Sub TextBox1_Change()
>
> TextBox1Cell.Value2 = TextBox1.Value
>
> End Sub
>
> If you also need the control on the form to update if the worksheet cell
> is changed for some other reason while the form is still open (a
> calculation, other code,…) then you can add code to your worksheet's
> Calculate and Change events.  If the cell will only contain a value and not
> a formula, you don't need the calculate event.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> With UserForm1
>
> If .Visible Then
>
> If Not Application.Intersect(Target, .TextBox1Cell) Is Nothing
> Then
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> With UserForm1
>
> If .Visible Then
>
> If .TextBox1.Value <> .TextBox1Cell.Value2 Then
>
>     .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 4:27 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Text Box - Properties
>
> ** **
>
> Hi
>
>  
>
> I have a userform open with a 'text box' .  Want to link with a cell in
> sheet.
>
>  
>
> However the 'text box'  properties does not show a 'linked cell'
> heading. I am sure it use to.  How do I restore the missing property or
> is there another text box I should use.
>
>  
>
> Thks
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data i

$$Excel-Macros$$ Text Box - Properties

[Cab Boose]

Hi

I have a userform open with a 'text box' .  Want to link with a cell in
sheet.

However the 'text box'  properties does not show a 'linked cell'
heading. I am sure it use to.  How do I restore the missing property or
is there another text box I should use.

Thks

Charlie

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Cloud Storage

[Cab Boose]

Hi

Is there anywhere online that MS Excel files can be stored and used.  No
look-a-likes but Excel.  Freeware or low cost.

Thanks

Charlie

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

[Cab Boose]

Hi Noorain

Works good now.  Thanks.

How do I get it to show also the range of cells in each name.  e.g.
List ASheet1  B.7:H50

Thanks

Charlie




On Wed, Jan 11, 2012 at 4:20 PM, NOORAIN ANSARI wrote:

> Dear Cab,
>
> Please try t...
>
> Sub listnames()
> Dim n As Name
> Dim i As Long
>
> For Each n In ThisWorkbook.Names
> i = i + 1
> Range("E" & i) = n.Name
> Next n
> End Sub
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Wed, Jan 11, 2012 at 6:20 AM, Cab Boose  wrote:
>
>> Hi
>>
>> Trying to get this to work. See below. Comes up with  'Invalid use of
>> porperty' ati = i + 1
>>
>>
>> I think the probem is in the Dim declaration for i.Has Dim i
>> As Name,  at the moment, have tried others instead of 'Name'  no luck.
>>
>> Want to list all Named Ranges (including Dynamic) in current
>> workbook. Need the Name and the range currently covered by that name.
>>
>> Thanks
>>
>> Charlie Harris
>>
>>
>>
>> Sub listnames()
>> Dim n As Name
>> Dim i As Name
>>
>> For Each n In ThisWorkbook.Names
>> i = i + 1
>> Range("E" & i) = n.Name
>> Next n
>>
>> End Sub
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ List of Dynamic & named ranges in workbook

[Cab Boose]

Hi

Trying to get this to work. See below. Comes up with  'Invalid use of
porperty' ati = i + 1


I think the probem is in the Dim declaration for i.Has Dim i As
Name,  at the moment, have tried others instead of 'Name'  no luck.

Want to list all Named Ranges (including Dynamic) in current workbook.
Need the Name and the range currently covered by that name.

Thanks

Charlie Harris



Sub listnames()
Dim n As Name
Dim i As Name

For Each n In ThisWorkbook.Names
i = i + 1
Range("E" & i) = n.Name
Next n

End Sub

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ List all Excel Workbooks

[Cab Boose]

Hi Don

That would be great.  I am on 2000 at the moment but should be upgrading to
2003 in a few days.

Regards

Charlie Harris





On Sat, Dec 24, 2011 at 2:40 AM, dguillett1  wrote:

>   Charlie, what is your excel version. I have one for xl2003 not updated
> for xl2007>, that searches all of my c drive and makes a list of 4000+
> files quickly. You could change to F:\ and it will search that one with sub
> folders files
> *name* *Date* *Size* *Full file Name* CabooseAddressVBA1 12/18/2011
> 06:39 145920 C:\emails\CabooseAddressVBA1.xls
>
> You may also
>*DOUBLE CLICK ON ROW 4 TO SORT BY THAT COLUMN* *DOUBLE CLICK ON
> Filename ROW in ANY COLUMN to OPEN that file* *Select Filename Row in Any
> Column & click Kill button to delete file and row*
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Thursday, December 22, 2011 3:45 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ List all Excel Workbooks
>
>  Hi
>
> There are plenty of solutions for listing open excel files.
>
> I would like to list all excel workbooks on my C:  and F: drives.   They
> are all over the place. My bad housekeeping!
>
> How do I get the complete address for each workbook ?   either with a
> hyperlink or not.  But do need to print out the list.
>
> Using Excel 2000 at the moment but soon hopefully to upgrade to 2003
>
> Thanks & Merry Christmas to all
>
> regards
>
>
> Charlie
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ List all Excel Workbooks

[Cab Boose]

Hi

After about 3 minutes (30Gig on hardrives) it came up with:
 Run-time error '-2144010224 (803500 10)':
Method 'Execute' of object 'FileSearch' failed

Your comments would be appreciated.

Thanks

Charlie Harris














On Fri, Dec 23, 2011 at 5:28 PM, siti Vi  wrote:

> Hi Charlie,
> Please check and try this code, if it helps...
>
> '---standard Module-
> Sub *GenerateList*()
>' sitiVi / jakarta 23 Dec 2011
>' in answering:
>' http://groups.google.com/group/ _
>' excel-macros/browse_thread/thread/9dbda650f1d09d65#
>'
>Dim ArDir As Variant, iDir As Integer
>' please edit this list of Path..
>ArDir = Array(*"C:\MyData", "F\", "E:\", "D\xFolder\yFolder"*)
>' ~~
>Application.Calculation = xlCalculationManual
>Application.ScreenUpdating = False
>For iDir = LBound(ArDir) To UBound(ArDir)
>   Call ListFiles(ArDir(iDir))
>Next iDir
>Columns("A:B").EntireColumn.AutoFit
>Application.ScreenUpdating = True
>Application.Calculation = xlCalculationAutomatic
> End Sub
>
> Private Sub *ListFiles*(ByVal SpecifiedDir As String)
>' sitiVi / jakarta 23 Dec 2011
>' in answering:
>' http://groups.google.com/group/ _
>' excel-macros/browse_thread/thread/9dbda650f1d09d65#
>'
>Dim vFName As Variant, RowN As Long
>RowN = Cells(1).CurrentRegion.Rows.Count
>If RowN = 1 Then RowN = 0
>With Application.FileSearch
>   .NewSearch
>   .LookIn = SpecifiedDir
>   .SearchSubFolders = True
>   .FileType = msoFileTypeExcelWorkbooks
>   REM .Execute
>   If .Execute > 0 Then
>  For Each vFName In .FoundFiles
> RowN = RowN + 1
> ActiveSheet.Cells(RowN, 1).Value = SpecifiedDir
> ActiveSheet.Cells(RowN, 2).Value = vFName
>  Next
>   End If
>End With
> End Sub
> '--end of code -
>
> Looking forward to hear if this code works (or not)..
>
> Thx, Best regards & Wassalamualaikum wr wb.
> siti Vi
>
>
>
> On Fri, Dec 23, 2011 at 4:45 AM, Cab Boose  wrote:
> >
> > Hi
> > There are plenty of solutions for listing open excel files.
> > I would like to list all excel workbooks on my C:  and F: drives.   They
> are all over the place. My bad housekeeping!
> > How do I get the complete address for each workbook ?   either with a
> hyperlink or not.  But do need to print out the list.
> > Using Excel 2000 at the moment but soon hopefully to upgrade to 2003
> > Thanks & Merry Christmas to all
> >
> > regards
> > Charlie
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ List all Excel Workbooks

[Cab Boose]

Hi

There are plenty of solutions for listing open excel files.

I would like to list all excel workbooks on my C:  and F: drives.   They
are all over the place. My bad housekeeping!

How do I get the complete address for each workbook ?   either with a
hyperlink or not.  But do need to print out the list.

Using Excel 2000 at the moment but soon hopefully to upgrade to 2003

Thanks & Merry Christmas to all

regards


Charlie

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

On Sun, Dec 18, 2011 at 9:18 AM, dguillett1  wrote:

Attached wbook





Hi Don
 This happens when I run the code-
   Highlights *SearchFormat:=*
 with msg: Compile error
 Named argument not found
  r1 = Range(Cells(1, "g"), Cells(lr, "g")).Find(What:="", After:=Cells(sr,
"G"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, *SearchFormat:=*True).Row


Thanks

Charlie Harris




>  Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>







>
>
>  *From:* Cab Boose 
> *Sent:* Saturday, December 17, 2011 2:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD
>
>  Hi Don & Noorain
> Thanks for your comments and ideas.
>
> I am taking one of our address lists and reducing the information in it as
> we will be doing everything by email and phone. Address etc not now
> required. Will also once this first task finished then classify into
> Catergory types for industries etc. A small 7 person business with some
> manufacturing and also online sales being developed.   Overall it leaves us
> with just the information we need.  The example is only a portion of the
> workbook.
>
> My apologies for not mentioning that not all companies will have a phone
> #  and/or  email address.
>
> Regards
>
> Charlie Harris
>
>
> On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Cab Boose,
>>
>> Please use try function.
>>
>> Copy this formula and paste it in define name and provide name range *
>> IsBold
>> =GET.CELL(20,INDIRECT("RC[1]",FALSE))
>>
>> See attached sheet for reference
>> *
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>
>> On Sat, Dec 17, 2011 at 3:16 AM, Cab Boose  wrote:
>>
>>> Hi Don
>>>
>>> The new code works well for the first few lines and then starts to
>>> repeat the same Phone number and same email address even though it has the
>>> company name correct.  A strange thing.  Note that athe repeat starts on
>>> the same row as the first email in G ?
>>>
>>> See attached.
>>>
>>> Thanks and regards
>>>
>>> Charlie
>>>
>>>  On Sat, Dec 17, 2011 at 3:29 AM, dguillett1 wrote:
>>>
>>>>   should do it
>>>>
>>>> Option Explicit
>>>> Sub foreachcoSAS()
>>>> Dim lr As Long
>>>> Dim dlr As Long
>>>>  Dim i As Long
>>>> Dim ph As Long
>>>> Dim em As Long
>>>> Dim c As Range
>>>>  i = 1
>>>> lr = Cells(Rows.Count, "g").End(xlUp).Row
>>>> For Each c In Range("g1:g" & lr)
>>>> dlr = Cells(Rows.Count, "H").End(xlUp).Row + 1
>>>>  If c.Font.Bold Then
>>>> 'MsgBox c
>>>> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
>>>> LookIn:=xlValues, _
>>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>>> 'MsgBox ph
>>>> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
>>>> LookIn:=xlValues, _
>>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>>> 'MsgBox em
>>>> Cells(dlr, "H").Value = Cells(c.Row, "g").Value
>>>> Cells(dlr, "i").Value = Cells(ph, "g").Value
>>>> Cells(dlr, "j").Value = Cells(em, "g").Value
>>>>  i = i + em
>>>> End If
>>>> Next
>>>> Columns("H:j").AutoFit
>>>>  End Sub
>>>>
>>>> Don Guillett
>>>> SalesAid Software
>>>> dguille...@gmail.com
>>>>
>>>>  *From:* Cab Boose 
>>>> *Sent:* Friday, December 16, 2011 12:28 AM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD
>>>>
>>>>   Hi Don
>>>>  Thanks for code. Wow it works great and fast.
>>>>  In the line of code that puts the info into col H , how do I put into
>>>> 3 different colums ? Say H, I, J.
>>>>  I could run text to columns on the result but would prefer to do it
>>>> with code
>>>>  Thanks

Re: $$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

Hi Don & Noorain
Thanks for your comments and ideas.

I am taking one of our address lists and reducing the information in it as
we will be doing everything by email and phone. Address etc not now
required. Will also once this first task finished then classify into
Catergory types for industries etc. A small 7 person business with some
manufacturing and also online sales being developed.   Overall it leaves us
with just the information we need.  The example is only a portion of the
workbook.

My apologies for not mentioning that not all companies will have a phone #
and/or  email address.

Regards

Charlie Harris


On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI wrote:

> Dear Cab Boose,
>
> Please use try function.
>
> Copy this formula and paste it in define name and provide name range *
> IsBold
> =GET.CELL(20,INDIRECT("RC[1]",FALSE))
>
> See attached sheet for reference
> *
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Sat, Dec 17, 2011 at 3:16 AM, Cab Boose  wrote:
>
>> Hi Don
>>
>> The new code works well for the first few lines and then starts to repeat
>> the same Phone number and same email address even though it has the company
>> name correct.  A strange thing.  Note that athe repeat starts on the same
>> row as the first email in G ?
>>
>> See attached.
>>
>> Thanks and regards
>>
>> Charlie
>>
>> On Sat, Dec 17, 2011 at 3:29 AM, dguillett1  wrote:
>>
>>>   should do it
>>>
>>> Option Explicit
>>> Sub foreachcoSAS()
>>> Dim lr As Long
>>> Dim dlr As Long
>>> Dim i As Long
>>> Dim ph As Long
>>> Dim em As Long
>>> Dim c As Range
>>> i = 1
>>> lr = Cells(Rows.Count, "g").End(xlUp).Row
>>> For Each c In Range("g1:g" & lr)
>>> dlr = Cells(Rows.Count, "H").End(xlUp).Row + 1
>>> If c.Font.Bold Then
>>> 'MsgBox c
>>> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
>>> LookIn:=xlValues, _
>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>> 'MsgBox ph
>>> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
>>> LookIn:=xlValues, _
>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>> 'MsgBox em
>>> Cells(dlr, "H").Value = Cells(c.Row, "g").Value
>>> Cells(dlr, "i").Value = Cells(ph, "g").Value
>>> Cells(dlr, "j").Value = Cells(em, "g").Value
>>> i = i + em
>>> End If
>>> Next
>>> Columns("H:j").AutoFit
>>> End Sub
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Friday, December 16, 2011 12:28 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD
>>>
>>>  Hi Don
>>>  Thanks for code. Wow it works great and fast.
>>>  In the line of code that puts the info into col H , how do I put into
>>> 3 different colums ? Say H, I, J.
>>>  I could run text to columns on the result but would prefer to do it
>>> with code
>>>  Thanks
>>>  Charlie
>>>
>>>
>>> On Fri, Dec 16, 2011 at 1:56 PM, dguillett1 wrote:
>>>
>>>>   One way
>>>>
>>>> Option Explicit
>>>>
>>>> Sub foreachcoSAS()
>>>> Dim lr As Long
>>>> Dim i As Long
>>>> Dim ph As Long
>>>> Dim em As Long
>>>> Dim c As Range
>>>> Dim ms As String
>>>>
>>>> i = 1
>>>> lr = Cells(Rows.Count, "g").End(xlUp).Row
>>>> For Each c In Range("g1:g" & lr)
>>>> If c.Font.Bold Then
>>>> 'MsgBox c
>>>> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
>>>> LookIn:=xlValues, _
>>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>>> 'MsgBox ph
>>>> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
>>>> LookIn:=xlValues, _
>>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>>> 'Ms

Re: $$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

Hi Don
 Thanks for code. Wow it works great and fast.
 In the line of code that puts the info into col H , how do I put into 3
different colums ? Say H, I, J.
   I could run text to columns on the result but would prefer to do it with
code
  Thanks
 Charlie


On Fri, Dec 16, 2011 at 1:56 PM, dguillett1  wrote:

>   One way
>
> Option Explicit
>
> Sub foreachcoSAS()
> Dim lr As Long
> Dim i As Long
> Dim ph As Long
> Dim em As Long
> Dim c As Range
> Dim ms As String
>
> i = 1
> lr = Cells(Rows.Count, "g").End(xlUp).Row
> For Each c In Range("g1:g" & lr)
> If c.Font.Bold Then
> 'MsgBox c
> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"), LookIn:=xlValues,
> _
> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
> 'MsgBox ph
> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
> LookIn:=xlValues, _
> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
> 'MsgBox em
> ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & " " & Cells(em, "g")
> Cells(Rows.Count, "h").End(xlUp).Offset(1) = ms
> 'MsgBox ms
> i = i + em
> End If
> Next
> Columns("H").AutoFit
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Thursday, December 15, 2011 4:12 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VBA select data in BOLD
>
>  Hi
>
> Have addresses like this:   (columnG)
>
> ABC COMPANY
> 123 Delta St
> Town
> Ph   0800123456
> fax  234567
> email1...@dfg.com
>
> Sometimes there are more rows with irrelvant informtation
>
> I want to select 3 of the rows :
>
> ABC COMPANY Ph  0800123456 email   1...@dfg.com
>
> And place them in  a single row in column A, B, C
>
> Company line will always be BOLD
> Phone line will always start with   'Ph'
> Email line will always start with 'email'  or have the '@'
>
>
> Once done the original codes will all be deleted leaving just the 3
> columns A-C
> I will do a sort then and get all the blank rows deleted.
>
>
>
>
> For Each cell In RangeG:
> If cell.Font.Bold = True Then
> Range.SelectA:
> Paste
> ..I have got lost already.
>
>
> Can you give some ideas for me.
>
> Thanks
>
>
> Charlie Harris
>
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

Hi

Have addresses like this:   (columnG)

ABC COMPANY
123 Delta St
Town
Ph   0800123456
fax  234567
email1...@dfg.com

Sometimes there are more rows with irrelvant informtation

I want to select 3 of the rows :

ABC COMPANY Ph  0800123456 email   1...@dfg.com

And place them in  a single row in column A, B, C

Company line will always be BOLD
Phone line will always start with   'Ph'
Email line will always start with 'email'  or have the '@'


Once done the original codes will all be deleted leaving just the 3 columns
A-C
I will do a sort then and get all the blank rows deleted.




 For Each cell In RangeG:
If cell.Font.Bold = True Then
Range.SelectA:
Paste
..I have got lost already.


Can you give some ideas for me.

Thanks


Charlie Harris

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Inventory management

[Cab Boose]

Hi Sushil

I cannot get the link to open.  Are you able to email to me a xl file ?

Thanks

Charlie

On Wed, Dec 14, 2011 at 8:26 PM, sushil kumar wrote:

> Hi Manhar,
>
> Please see this link http://31.222.142.10:8080/openerp/login?db=&user=
>
> Database:ManufacturingM
> User: admin
> password:admin1
> This is opensource application if you want we can setup for you and
> customize according to your need
>
> Looking foward to help you
>
> Thanks,
> Sushil
>
>
> On Wed, Dec 14, 2011 at 12:10 PM, arif massani wrote:
>
>> http://www.excel-skills.com/excel_templates.asp#InventoryUsage
>> See This Link May Help you
>>
>> Or Contact me on my personal email address
>> arifmass...@gmail.com
>>
>>
>> On Wed, Dec 14, 2011 at 12:00 PM, manhar prajapati <
>> prajapati.man...@gmail.com> wrote:
>>
>>> Hi
>>>
>>> any one have inventory management worksheet???
>>>
>>> If yes please provide me as i have manufacturing unit i want for my
>>> company
>>>
>>> Regards
>>> Manhar Prajapati
>>>
>>> --
>>>
>>>
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Arif Mansoorali Massani
>> Bhavnagar
>> State Gujarat, India
>> M. +91-8530292142
>> http://arifmassani.webs.com/
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Import PDF into Excel

[Cab Boose]

Hi

I would like to use the 'File-Open'  command in Excel to bring in a pdf
file and have it finish up in .xls format.  Is there an add-in to do this
automatically or a vba way to have it converted.  Most of the on-line
require the conversion to excel  to be done before and creates its own
workbook.  I will be using the same workbook each time. Deleting previous
history each time.
The file is inventory listing in a stock program and only comes in PDF.

In the end result I am going to use vba to get the file off  c: drive etc,
get into .xls, and then do some manipulating of figures etc, and produce a
new report in .xls

My request is how to convert to .xls from within workbook.

Thanks

Charlie Harris

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Paste into a Named Range

[Cab Boose]

Hi Don

Wow, works just like magic.   Still reading it over and over to see how it
works. What part of the code says to   'cut' and and also  the 'paste'  ?
For testing my project I would like to drun that code every 5 seconds for a
max of 10 times. Like having a macro to 'call ' this macro and then run
every 5 second for 10 times only.

Appreciate your excellent help.

Thankyou

Charlie Harris
Downunder in New Zealand

On Wed, Oct 19, 2011 at 2:09 AM, dguillett1  wrote:

>   I changed your “drag” defined name and it now will update the name
> properly if you drag to the next available row in the named range. Or, you
> may double click on the cell in col F and the f & g row will be copied to
> the next available row.
>
> If you are saying that you want to drag, in say row 13, from col F to col M
> and have the data flow to the next available row. You may double click or
> drag from f:g to M: & O
>
> Option Explicit
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
> If Target.Column <> 6 Then Exit Sub
> Target.Resize(, 2).Cut Cells(Rows.Count, "m").End(xlUp).Offset(1)
> End Sub
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Dim tr As Long
> Dim br As Long
> If Target.Column <> 13 Or _
> Intersect(Target, Columns("M:N")) Is Nothing Then Exit Sub
> If Cells(Rows.Count, "M").End(xlUp).Offset(-2) = "" Then
> tr = Cells(9, "m").End(xlDown).Row + 1
> br = Cells(Rows.Count, "M").End(xlUp).Row
> Cells(tr, "m").Resize(br - tr, 2).Delete
> End If
> End Sub
> Sub fixit() 'fire if event code stops working
> Application.EnableEvents = True
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Tuesday, October 18, 2011 3:06 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Paste into a Named Range
>
>  Hi Don
>
> Further to your suggestion of using the offset etc.  I have included in
> attached workbook, but if I drag a number into column A it places it where I
> place it and not in next available row.  Would you mind checking and see if
> I have this set up correctly. When fixed I can use recorder to get code.
>
>
> Thanks and regards
>
> Charlie Harris
>
>
> On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose  wrote:
>
>>
>> Hi Don and ChilExcel
>>
>> Thanks for info. Don like earlier I have not put enough info. I should
>> learn from this.
>>
>> See attached workbook with comments.
>>
>> Thanks, apologies and regards
>>
>> Charlie Harris
>>   On Tue, Oct 18, 2011 at 12:29 PM, dguillett1 wrote:
>>
>>>   If you have a defined name range such as myrng defined using this,
>>> then if you  drag to col A it will extend the named range to accommodate the
>>> new data.  assumes numbers. If numbers in col A, use 99 or any
>>> number greater than you might use
>>> =OFFSET(Sheet1!$A$2,0,0,MATCH("",Sheet1!$A:$A),2)
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Monday, October 17, 2011 5:57 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Paste into a Named Range
>>>
>>>   Hi
>>>
>>> I have a 2 cells in a row that I want to copy into a named range (say
>>> 'serialNo')  also only 2 columns.
>>>
>>> Do I have to do the vba xcell up routine ?  or should I be able to paste
>>> into   'serialno' and it will go into next available row.  I have tried
>>> recording  copy/paste, select 'serialno' but not successful.
>>>
>>>
>>>
>>>
>>> Thanks
>>>
>>>
>>> Charlie Harris
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><>&l

Re: $$Excel-Macros$$ Paste into a Named Range

[Cab Boose]

Hi Don

Further to your suggestion of using the offset etc.  I have included in
attached workbook, but if I drag a number into column A it places it where I
place it and not in next available row.  Would you mind checking and see if
I have this set up correctly. When fixed I can use recorder to get code.


Thanks and regards

Charlie Harris


On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose  wrote:

>
> Hi Don and ChilExcel
>
> Thanks for info. Don like earlier I have not put enough info. I should
> learn from this.
>
> See attached workbook with comments.
>
> Thanks, apologies and regards
>
> Charlie Harris
> On Tue, Oct 18, 2011 at 12:29 PM, dguillett1  wrote:
>
>>   If you have a defined name range such as myrng defined using this, then
>> if you  drag to col A it will extend the named range to accommodate the new
>> data.  assumes numbers. If numbers in col A, use 99 or any number
>> greater than you might use
>> =OFFSET(Sheet1!$A$2,0,0,MATCH("",Sheet1!$A:$A),2)
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Cab Boose 
>> *Sent:* Monday, October 17, 2011 5:57 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Paste into a Named Range
>>
>>  Hi
>>
>> I have a 2 cells in a row that I want to copy into a named range (say
>> 'serialNo')  also only 2 columns.
>>
>> Do I have to do the vba xcell up routine ?  or should I be able to paste
>> into   'serialno' and it will go into next available row.  I have tried
>> recording  copy/paste, select 'serialno' but not successful.
>>
>>
>>
>>
>> Thanks
>>
>>
>> Charlie Harris
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


PasteToNamedRg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Paste into a Named Range

[Cab Boose]

Hi Don and ChilExcel

Thanks for info. Don like earlier I have not put enough info. I should learn
from this.

See attached workbook with comments.

Thanks, apologies and regards

Charlie Harris
On Tue, Oct 18, 2011 at 12:29 PM, dguillett1  wrote:

>   If you have a defined name range such as myrng defined using this, then
> if you  drag to col A it will extend the named range to accommodate the new
> data.  assumes numbers. If numbers in col A, use 99 or any number
> greater than you might use
> =OFFSET(Sheet1!$A$2,0,0,MATCH("",Sheet1!$A:$A),2)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Monday, October 17, 2011 5:57 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Paste into a Named Range
>
>  Hi
>
> I have a 2 cells in a row that I want to copy into a named range (say
> 'serialNo')  also only 2 columns.
>
> Do I have to do the vba xcell up routine ?  or should I be able to paste
> into   'serialno' and it will go into next available row.  I have tried
> recording  copy/paste, select 'serialno' but not successful.
>
>
>
>
> Thanks
>
>
> Charlie Harris
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


PasteToNamedRg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Toggle a Cell value

[Cab Boose]

Hi Sam

Works very well.  Thankyou Sam and Don for your inputs.

REgards

Charlie

On Sun, Oct 16, 2011 at 9:55 PM, Sam Mathai Chacko wrote:

> I don't necessarily support this alternative, and I don't think it is
> popular among the old schools either, but it is effective nonetheless. There
> is a certain Hyperlink event which could be modified to bamboozle Excel and
> make it work to your advantage. The trick is to create a hyperlink to the
> same cell from within itself, and then use the event macro.
>
> I have attached a modified version of the same here. The green line is just
> added as an embellishment. You can ignore that if not needed.
>
> *Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
>
> With Target.Parent
> If .Address(0, 0) = "G15" Then
> Target.ScreenTip = "Click to reverse direction of the motor"
> .Value = Abs(CLng(Not -.Value))
> End If
> End With
>
> End Sub
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> *
> On Sun, Oct 16, 2011 at 12:06 PM, Cab Boose  wrote:
>
>> Hi Don & Sam
>>
>> Don.   appreciate your comment.  I had not made it clear what I was
>> looking for.  Apologies.
>>
>> Sam, yes it is working great with dbl click or right click.  It does not
>> work with a single click, which is what I prefer.  In use the cell would be
>> selected and then may also need to click once again to change the cell to
>> requirement.
>>
>> Your comments would be appreciated.
>>
>> Thanks
>>
>> Charlie Harris
>>
>> On Sun, Oct 16, 2011 at 12:13 AM, dguillett1 wrote:
>>
>>>   Your request was “when I SELECT the cell”. So, as Sam says, use
>>> another event such as doubleclick.
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Friday, October 14, 2011 8:32 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value
>>>
>>>  Hi Don and Sam
>>>
>>> Thanks for your input.
>>>
>>> I use Win7  Excel  and on a laptop.
>>>
>>>
>>> Don, your code work ok but  small hiccup.  The code/color changes ok when
>>> I select a different cell and then come back to actual cell again.  Color
>>> and number change as required.  However I would like to be able to leave the
>>> cursor in the active cell, somethimes,  and each time I tap the cell on the
>>> laptop pad, it should change. That is without having to go to another
>>> cell first.  In other words how do you get Excel to know when you select
>>> cell and then select again without moving.  Maybe if we can after the first
>>> selection and change of color/code Excel places the active cell into a
>>> default cell nearby, and if the direction needs to be changed again I need
>>> to select that cell again.  Or is there a way of refreshing the g15 cell
>>> without moving.
>>>
>>> Sam, your code brings up a   run time error '13'   type mismatch.  The
>>> color is ok by format, but does the code allow for changing the value in the
>>> cell back and forth from 1 to 0 and 0 to 1 .
>>>
>>>
>>> Thankyou all
>>>
>>> Charlie Harris
>>>
>>>
>>>
>>>
>>>
>>> On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko 
>>> wrote:
>>>
>>>> This should do it
>>>>
>>>>
>>>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>>>
>>>> If Target.Address(0, 0) = "G15" Then
>>>> Target.Value = Abs(CLng(Not -Target.Value))
>>>> End If
>>>>
>>>> End Sub
>>>>
>>>> Use a conditional format for coloring the cell.
>>>>
>>>> If you do not want to add a conditional format (which is faster than VBA
>>>> by the way), and do the coloring also through VBA, then just add the
>>>> following line within the If End IF statement in the VBA above.
>>>>
>>>> Target.Interior.ColorIndex = 4 - Target.Value
>>>>
>>>> Regards,
>>>>
>>>> Sam Mathai Chacko
>>>>
>>>>
>>>> On Fri, Oct 14, 2011 at 6:09 PM, dguillett1 wrote:
>>>>
>>>>>   Right click sheet tab>view code>copy/paste this to make the changes
>>>>> in col G
>>>

$$Excel-Macros$$ Paste into a Named Range

[Cab Boose]

Hi

I have a 2 cells in a row that I want to copy into a named range (say
'serialNo')  also only 2 columns.

Do I have to do the vba xcell up routine ?  or should I be able to paste
into   'serialno' and it will go into next available row.  I have tried
recording  copy/paste, select 'serialno' but not successful.




Thanks


Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Toggle a Cell value

[Cab Boose]

Hi Don & Sam

Don.   appreciate your comment.  I had not made it clear what I was looking
for.  Apologies.

Sam, yes it is working great with dbl click or right click.  It does not
work with a single click, which is what I prefer.  In use the cell would be
selected and then may also need to click once again to change the cell to
requirement.

Your comments would be appreciated.

Thanks

Charlie Harris

On Sun, Oct 16, 2011 at 12:13 AM, dguillett1  wrote:

>   Your request was “when I SELECT the cell”. So, as Sam says, use another
> event such as doubleclick.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Friday, October 14, 2011 8:32 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value
>
>  Hi Don and Sam
>
> Thanks for your input.
>
> I use Win7  Excel  and on a laptop.
>
>
> Don, your code work ok but  small hiccup.  The code/color changes ok when I
> select a different cell and then come back to actual cell again.  Color and
> number change as required.  However I would like to be able to leave the
> cursor in the active cell, somethimes,  and each time I tap the cell on the
> laptop pad, it should change. That is without having to go to another
> cell first.  In other words how do you get Excel to know when you select
> cell and then select again without moving.  Maybe if we can after the first
> selection and change of color/code Excel places the active cell into a
> default cell nearby, and if the direction needs to be changed again I need
> to select that cell again.  Or is there a way of refreshing the g15 cell
> without moving.
>
> Sam, your code brings up a   run time error '13'   type mismatch.  The
> color is ok by format, but does the code allow for changing the value in the
> cell back and forth from 1 to 0 and 0 to 1 .
>
>
> Thankyou all
>
> Charlie Harris
>
>
>
>
>
> On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko wrote:
>
>> This should do it
>>
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>
>> If Target.Address(0, 0) = "G15" Then
>> Target.Value = Abs(CLng(Not -Target.Value))
>> End If
>>
>> End Sub
>>
>> Use a conditional format for coloring the cell.
>>
>> If you do not want to add a conditional format (which is faster than VBA
>> by the way), and do the coloring also through VBA, then just add the
>> following line within the If End IF statement in the VBA above.
>>
>> Target.Interior.ColorIndex = 4 - Target.Value
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Fri, Oct 14, 2011 at 6:09 PM, dguillett1  wrote:
>>
>>>   Right click sheet tab>view code>copy/paste this to make the changes in
>>> col G
>>>
>>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>> If Target.Column <> 7 Or Target.Count > 1 Then Exit Sub
>>> If Target = 1 Then
>>> Target = 0
>>> Target.Interior.ColorIndex = 4
>>> Else
>>> Target = 1
>>> Target.Interior.ColorIndex = 3
>>> End If
>>> End Sub
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Friday, October 14, 2011 2:33 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Toggle a Cell value
>>>
>>>   Hi eveyrone
>>>
>>> See attached sheet.
>>>
>>> For a 12 volt motor speed direction, Forward or Reverse  I want to have a
>>> value of a cell to toggle back and forth between 0 and 1 and cell color also
>>> to change each time between green and red.
>>>
>>> Prefer to use a cell than use a toggle button, unless a toggle button can
>>> change colors etc and the value of 0 or 1  from the toggle button can be
>>> used to export etc
>>>
>>> Your comments would be appreciated.
>>>
>>> Charlie Harris
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
&g

Re: $$Excel-Macros$$ Toggle a Cell value

[Cab Boose]

Hi Don and Sam

Thanks for your input.

I use Win7  Excel  and on a laptop.


Don, your code work ok but  small hiccup.  The code/color changes ok when I
select a different cell and then come back to actual cell again.  Color and
number change as required.  However I would like to be able to leave the
cursor in the active cell, somethimes,  and each time I tap the cell on the
laptop pad, it should change. That is without having to go to another
cell first.  In other words how do you get Excel to know when you select
cell and then select again without moving.  Maybe if we can after the first
selection and change of color/code Excel places the active cell into a
default cell nearby, and if the direction needs to be changed again I need
to select that cell again.  Or is there a way of refreshing the g15 cell
without moving.

Sam, your code brings up a   run time error '13'   type mismatch.  The color
is ok by format, but does the code allow for changing the value in the cell
back and forth from 1 to 0 and 0 to 1 .


Thankyou all

Charlie Harris





On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko wrote:

> This should do it
>
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> If Target.Address(0, 0) = "G15" Then
> Target.Value = Abs(CLng(Not -Target.Value))
> End If
>
> End Sub
>
> Use a conditional format for coloring the cell.
>
> If you do not want to add a conditional format (which is faster than VBA by
> the way), and do the coloring also through VBA, then just add the following
> line within the If End IF statement in the VBA above.
>
> Target.Interior.ColorIndex = 4 - Target.Value
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Fri, Oct 14, 2011 at 6:09 PM, dguillett1  wrote:
>
>>   Right click sheet tab>view code>copy/paste this to make the changes in
>> col G
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>> If Target.Column <> 7 Or Target.Count > 1 Then Exit Sub
>> If Target = 1 Then
>> Target = 0
>> Target.Interior.ColorIndex = 4
>> Else
>> Target = 1
>> Target.Interior.ColorIndex = 3
>> End If
>> End Sub
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Cab Boose 
>> *Sent:* Friday, October 14, 2011 2:33 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Toggle a Cell value
>>
>>  Hi eveyrone
>>
>> See attached sheet.
>>
>> For a 12 volt motor speed direction, Forward or Reverse  I want to have a
>> value of a cell to toggle back and forth between 0 and 1 and cell color also
>> to change each time between green and red.
>>
>> Prefer to use a cell than use a toggle button, unless a toggle button can
>> change colors etc and the value of 0 or 1  from the toggle button can be
>> used to export etc
>>
>> Your comments would be appreciated.
>>
>> Charlie Harris
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on fac

$$Excel-Macros$$ Toggle a Cell value

[Cab Boose]

Hi eveyrone

See attached sheet.

For a 12 volt motor speed direction, Forward or Reverse  I want to have a
value of a cell to toggle back and forth between 0 and 1 and cell color also
to change each time between green and red.

Prefer to use a cell than use a toggle button, unless a toggle button can
change colors etc and the value of 0 or 1  from the toggle button can be
used to export etc

Your comments would be appreciated.

Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CellToggle.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Counter in a Cell

[Cab Boose]

Hi Daniel

Wow, works wonderfully well.  Very much appreciated.

Regards

Charlie

On Sun, Sep 4, 2011 at 11:54 PM, Daniel  wrote:

> See attached workbook.
>
> ** **
>
> HTH
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* dimanche 4 septembre 2011 03:05
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Counter in a Cell
>
> ** **
>
> Hi Everbody
>
>  
>
> Thanks for all your options.
>
>  
>
> I would like to explain a little more.   I want a small 5 pad keyboard to
> plug usb into laptop. Operator will not necessary have access to screen.
> The operator will just use up or down  button to change the speed.  So the
> H11 will need to be frozen I guess and then count the ups and downs and show
> a number in that cell.
>
>  
>
> Daniel - your macro looks like doing as required, but I have tried with
> cursor in H11 and press the up or down, message comes up with unable to find
> macro.  Now I have your second emailed macro  in the Wookbook module.  Do I
> still need some of the macro in the first email in a module?
>
>  
>
> Attached workbook as I have at the moment.
>
>  
>
> Appreciate all your work everyone.
>
>  
>
> thanks
>
>  
>
> Charlie Harris
>
> On Sun, Sep 4, 2011 at 3:18 AM, Excel Inspiration <
> xcel.inspirat...@gmail.com> wrote:
>
> Mr.Charlie,
>
>  
>
> Please find the attached file. I have used Spin button (Form Control). It
> can be used another sheet linked with sheet 1 – H11 as you requested.
>
>  
>
> *- Xcel Inspiration*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* 03 September 2011 05:13
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Counter in a Cell
>
>  
>
> Hi
>
>  
>
> In attached Sheet1, I want the cell to count from 0 to 16 up and down in
> between. The count is of times up arrow and down arrow are pressed.
>
>  
>
> To set speed from, 0 to 16 for model railroad project.
>
>  
>
> Your advice appreciated.
>
>  
>
> Thanks
>
>  
>
> Charlie Harris
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send

Re: $$Excel-Macros$$ Counter in a Cell

[Cab Boose]

Hi Everbody

Thanks for all your options.

I would like to explain a little more.   I want a small 5 pad keyboard to
plug usb into laptop. Operator will not necessary have access to screen.
The operator will just use up or down  button to change the speed.  So the
H11 will need to be frozen I guess and then count the ups and downs and show
a number in that cell.

Daniel - your macro looks like doing as required, but I have tried with
cursor in H11 and press the up or down, message comes up with unable to find
macro.  Now I have your second emailed macro  in the Wookbook module.  Do I
still need some of the macro in the first email in a module?

Attached workbook as I have at the moment.

Appreciate all your work everyone.

thanks

Charlie Harris

On Sun, Sep 4, 2011 at 3:18 AM, Excel Inspiration <
xcel.inspirat...@gmail.com> wrote:

> Mr.Charlie,
>
> ** **
>
> Please find the attached file. I have used Spin button (Form Control). It
> can be used another sheet linked with sheet 1 – H11 as you requested.
>
> ** **
>
> *- Xcel Inspiration***
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* 03 September 2011 05:13
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Counter in a Cell
>
> ** **
>
> Hi
>
>  
>
> In attached Sheet1, I want the cell to count from 0 to 16 up and down in
> between. The count is of times up arrow and down arrow are pressed.
>
>  
>
> To set speed from, 0 to 16 for model railroad project.
>
>  
>
> Your advice appreciated.
>
>  
>
> Thanks
>
>  
>
> Charlie Harris
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Counter in a Cell

[Cab Boose]

Hi

In attached Sheet1, I want the cell to count from 0 to 16 up and down in
between. The count is of times up arrow and down arrow are pressed.

To set speed from, 0 to 16 for model railroad project.

Your advice appreciated.

Thanks

Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CellCountUpDown.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)

[Cab Boose]

Hi Daniel
Thanks for your response.  I am having a look at this
http://www.aggsoft.com/print-asdl-excel-real-time-charting-export.htm.  But
I do not think it will do what I want.  It goes from device to excel.

Just to explain a little more of what I am trying to do. (way out of my
range of ability, but I hope I can find software like above only the correct
way),  In the early 1980s a digital model railway controller was developed
by Hornby UK.  I would like to be able to use the receivers in the locos etc
and operate from pc.  Power supply is ok.   The controller sends data down
the line to the receiver which is a Texas Instruments TMS100 series 4 bit
processor.  I have oscilloscope drawings of the waveform and breakdown of
data.  I can setup on Excel all the commends etc and work out how to convert
into necessary language to go down serial or USB (USB prefably) to the
device.  Then a lot of testing and trials etc.   The current system is
limited to 16 loco addresses which I will increase up to 64 (I hope)
There is a new system called DCC but pricing is quite esxpensve for me and I
have lots of receivers etc all paid  for. Can pick up used receivers quite
cheap.

So at the moment I would like to get hold of some Excel compatible software
or add-in to take care of converting the numeral  instructions from cell in
Excel and converting into binary or whatever it has to be (have not
established that yet, and also to insert new instructions etc into the data
stream.  Looking at all the oscillosope data over the weekend.  Once
converted send it down thru the port and to the receiver device.

Not in a hurry and hope to learn heaps in the meantime.  It is possible I
guess that I find it cannot be done.
Thanks and regards
Charlie
On Thu, Sep 1, 2011 at 2:57 AM, Daniel  wrote:

> … or a driver ?
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 30 août 2011 05:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)
>
> ** **
>
> Hi once again
>
>  
>
> This is totally new subject.   I have model railroads.   I would like to
> control from Excel.(there are some other software available but I would
> like to use Excel)
>
>  
>
> I want to send from Excel to a bus wire digital information showing the
> loco number and direction of travel (fwd/rev) etc. Just for basics etc  Send
> a message by USB to say:
>
>  
>
> Controller1  Engine 5  Fwd Direction 1/2 speed
>
>  
>
> In practice there would be several sets of data for different locos.
>
>  
>
> There is a digital receiver in loco.  (I have drawings of waveforms that it
> is sent over etc)
>
>  
>
> I know there are lots of things to consider, but at this point I would like
> to know if anyone has done something similiar.  Is DDE the one to us (old
> apparantly) or something different.
>
>  
>
> I will make up a spreadsheet to show selection of loco etc
>
>  
>
> It may end up being too complex for me, but I would like to give it a try
> and get a ssample working turning on an LED etc
>
>  
>
> Thanks
>
>  
>
> Charlie Harris
>
> (into model trains)
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> &l

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

[Cab Boose]

Hi Noorain

Thanks for that.  It does not show in the add-in at the moment.  Have opened
Excel and then opened the file you sent.
Is there a process that I should foolw ?

Thankyou

Charlie

On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI wrote:

> Dear Cab,
>
> Actually it is Add-In file when you click on this, it will be Show in
> Add-in Menu bar when you need  it can be use..
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose  wrote:
>
>> Hi Noorain
>>
>>
>>
>>
>>  On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Cab,
>>>
>>>  Question -1, you can use attached Add in to Compare two worksheets..
>>> Question -2, You can group both sheets to same entry on same time.
>>>
>>> Press ctrl+shift+Pg down..
>>>   Thanks for your reply and attachment.
>>>
>>>
>> However the attachment opens Excel but will not show the workbook.
>>
>> If you could check and resend for me that would be great.
>> Thanks and regars
>>
>> Charlie Harris
>>
>>>
>>>
>>>
>>> On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose  wrote:
>>>
>>>> Hi  OOPS
>>>>
>>>> This time attached.
>>>>
>>>> Thanks
>>>>
>>>> Charlie
>>>>
>>>>   On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose  wrote:
>>>>
>>>>> Hi and oops.
>>>>>
>>>>> Attached now.
>>>>>
>>>>>   On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI <
>>>>> noorain.ans...@gmail.com> wrote:
>>>>>
>>>>>> Dear Cab,
>>>>>>
>>>>>> Attachment Missing.
>>>>>>
>>>>>>   On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>  I have in attached workbook:
>>>>>>>  Has two worksheets- 'ByGroups' and 'ByAssly"
>>>>>>>  The two sheets should be the same, however they are in different
>>>>>>> order.
>>>>>>>  First Question: Which is the best way to find the differences
>>>>>>> between the two sheets as at the moment so that corrections can be made.
>>>>>>> Have searched google etc Looks like I need a match/vlookup ?? or 
>>>>>>> probably
>>>>>>> vba would be better ? Would like to see a separate sheet with the
>>>>>>> differences.
>>>>>>>  Second Question: Once the sheets are sorted, I want to be able to
>>>>>>> have entries made onto the part # in each sheet at the same time. eg if 
>>>>>>> I
>>>>>>> have part # 27184 I want to enter 'InStock' number entered on both 
>>>>>>> sheets
>>>>>>> against that number. I think a user form could be used, but I do not 
>>>>>>> know
>>>>>>> how to get both sheets entered at the same time. The user form would 
>>>>>>> show
>>>>>>> the 5 column heading (on the RHS)
>>>>>>>  Your comments and guidance would be appreciated.
>>>>>>>
>>>>>>> Thankyou
>>>>>>>
>>>>>>> Charlie Harris
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> --
>>>>>>> Some important links for excel users:
>>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>>> http://twitter.com/exceldailytip
>>>>>>> 2. Join our LinkedIN group @
>>>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>>>
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> <><><><><><><><><>&

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

[Cab Boose]

Hi Noorain




On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI wrote:

> Dear Cab,
>
> Question -1, you can use attached Add in to Compare two worksheets..
> Question -2, You can group both sheets to same entry on same time.
>
> Press ctrl+shift+Pg down..
> Thanks for your reply and attachment.
>
>
However the attachment opens Excel but will not show the workbook.

If you could check and resend for me that would be great.
Thanks and regars

Charlie Harris

>
>
>
> On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose  wrote:
>
>> Hi  OOPS
>>
>> This time attached.
>>
>> Thanks
>>
>> Charlie
>>
>>   On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose  wrote:
>>
>>> Hi and oops.
>>>
>>> Attached now.
>>>
>>>   On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Dear Cab,
>>>>
>>>> Attachment Missing.
>>>>
>>>>   On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose  wrote:
>>>>
>>>>> Hi
>>>>>  I have in attached workbook:
>>>>>  Has two worksheets- 'ByGroups' and 'ByAssly"
>>>>>  The two sheets should be the same, however they are in different
>>>>> order.
>>>>>  First Question: Which is the best way to find the differences between
>>>>> the two sheets as at the moment so that corrections can be made. Have
>>>>> searched google etc Looks like I need a match/vlookup ?? or probably vba
>>>>> would be better ? Would like to see a separate sheet with the differences.
>>>>>  Second Question: Once the sheets are sorted, I want to be able to
>>>>> have entries made onto the part # in each sheet at the same time. eg if I
>>>>> have part # 27184 I want to enter 'InStock' number entered on both sheets
>>>>> against that number. I think a user form could be used, but I do not know
>>>>> how to get both sheets entered at the same time. The user form would show
>>>>> the 5 column heading (on the RHS)
>>>>>  Your comments and guidance would be appreciated.
>>>>>
>>>>> Thankyou
>>>>>
>>>>> Charlie Harris
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.face

$$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)

[Cab Boose]

Hi once again

This is totally new subject.   I have model railroads.   I would like to
control from Excel.(there are some other software available but I would
like to use Excel)

I want to send from Excel to a bus wire digital information showing the loco
number and direction of travel (fwd/rev) etc. Just for basics etc  Send a
message by USB to say:

Controller1  Engine 5  Fwd Direction 1/2 speed

In practice there would be several sets of data for different locos.

There is a digital receiver in loco.  (I have drawings of waveforms that it
is sent over etc)

I know there are lots of things to consider, but at this point I would like
to know if anyone has done something similiar.  Is DDE the one to us (old
apparantly) or something different.

I will make up a spreadsheet to show selection of loco etc

It may end up being too complex for me, but I would like to give it a try
and get a ssample working turning on an LED etc

Thanks

Charlie Harris
(into model trains)

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Named Range to Dynamic with VBA

[Cab Boose]

Hi

I would like to select an already named range and using a command button
convert it to dynamic named range by columns and rows.

Is this possible ? It would be a lot quicker than doing it manually each
time.  I failed to make a lot dynamic when I set them up.

Appreciate your help, I am aged !! (67) and do part time work just a few
hours a week for a small business.  Love Excel.

Thanks and regards


Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Stock Sheets x 2 to equal each other

[Cab Boose]

Hi
 I have in attached workbook:
 Has two worksheets- 'ByGroups' and 'ByAssly"
 The two sheets should be the same, however they are in different order.
 First Question: Which is the best way to find the differences between the
two sheets as at the moment so that corrections can be made. Have searched
google etc Looks like I need a match/vlookup ?? or probably vba would be
better ? Would like to see a separate sheet with the differences.
 Second Question: Once the sheets are sorted, I want to be able to have
entries made onto the part # in each sheet at the same time. eg if I have
part # 27184 I want to enter 'InStock' number entered on both sheets against
that number. I think a user form could be used, but I do not know how to get
both sheets entered at the same time. The user form would show the 5 column
heading (on the RHS)
 Your comments and guidance would be appreciated.

Thankyou

Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ VLOOKUP or Similiar

[Cab Boose]

Hi Noorain

I have tried it using normal vlookup and it works great.I thought that
in the column that the number is searched in had to be a column with no
blanks.   I had not tried when I sent email.  Have tried now and it is ok.

Apologies for taking up your time.

Regards

Charlie
On Mon, Aug 29, 2011 at 11:18 AM, NOORAIN ANSARI
wrote:

> Dear Cab,
>
> If possible please provide a sample sheet..
>
> On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose  wrote:
>
>> Hi
>>
>>
>> I have a list of data 5 columns 1000 rows. There are some blank rows in
>> this list. Sometimes one sometimes several. I do not want to delete the
>> rows.
>>  I want a vlookup function or similiar, to lookup column A for the
>> required number and copy into normal cell where formula is. That is: just a
>> normal vllookup function.
>>
>> Question:How do I get the vlookup to go past the first blank row ?
>>  Thanks
>>  Charlie
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ VLOOKUP or Similiar

[Cab Boose]

Hi


I have a list of data 5 columns 1000 rows. There are some blank rows in this
list. Sometimes one sometimes several. I do not want to delete the rows.
 I want a vlookup function or similiar, to lookup column A for the required
number and copy into normal cell where formula is. That is: just a normal
vllookup function.

Question:How do I get the vlookup to go past the first blank row ?
 Thanks
 Charlie

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

[Cab Boose]

Hi

Have justg made a discovery.  If I open Win7 in SAFE mode I can access Excel
files!  It did ask if I wangted to load an add=in , I said no, and
everything wortked fine.  It is possible there is an add-in file somewhere
causing a problem.  Where do I find Add-In file.  St the moment I have
reinstalled and would not expect any add-in to be there.

Thnaks

Charlei

On Sat, Aug 6, 2011 at 7:29 PM, Cab Boose  wrote:

> Hi Everybody
>
> Thankyou for all your suggestions.
>
> Still no success.  Have tried new 'user',  have reinstalled Office 2000,
> have tried changing the settings in IE as per earlier email.
>
> Could it be a file that is causing a problem.  How would I change all the
> Excel file extension so that Excel would not recognise any of the files, try
> it, and then bring the files back in one by one to see what happens.
>
> Any other ideas would be much appreciatted.
>
> Thanks
>
> Charlie Harris
>
> On Sat, Aug 6, 2011 at 12:34 AM, Rajan_Verma wrote:
>
>>  *Follow The Link For your Answer :*
>>
>> * *
>>
>>
>> http://answers.microsoft.com/en-us/windows/forum/windows_7-desktop/does-microsoft-word-and-excel-2000-work-on-windows/845d0337-1348-4db3-a123-061c12cb26de
>> **
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
>> *Sent:* Friday, August 05, 2011 2:20 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed*
>> ***
>>
>> ** **
>>
>> *Hi **Charlie,*
>>
>> ** **
>>
>> *Please try with some Others  UserAccount Logins else Create a New Login
>> Account and try...*
>>
>> ** **
>>
>> *Best Regards,*
>>
>> *Venkat *
>>
>> *Chennai*
>>
>> ** **
>>
>> On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose  wrote:
>>
>> Hi Venkat
>>
>>  
>>
>> Thanks for the reference.  I was pretty sure that it would work.
>> Unfortuanately no.  I still get the same message.
>>
>>  
>>
>> Any other options ?   I am sure we will find it eventually.
>>
>>  
>>
>> Thanks
>>
>>  
>>
>> Charlie
>>
>>  
>>
>>  
>>
>>  
>>
>>
>>
>>  
>>
>> On Fri, Aug 5, 2011 at 6:19 PM, Venkat CV  wrote:*
>> ***
>>
>> Hi,
>>
>>  
>>
>> Look below links See if helps...
>>
>>  
>>
>>
>> http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/
>> 
>>
>>  
>>
>> ** **
>>
>> *Best Regards,*
>>
>> *Venkat *
>>
>> *Chennai*
>>
>> On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose  wrote:
>>
>> Hi
>>
>>  
>>
>> I am using Win7 and Excel 2000.
>>
>>  
>>
>> Have never had problems for years, but now all of a sudden Excel will not
>> open.  Comes up with :   "Windows can not access the specified device, path
>> or file."
>>
>>  
>>
>> I have been advised to reload Office 2000.  A couple of questions:
>>
>>  
>>
>> 1.  Do I reload all of Office 2000 or is it best just to reload the
>> excel.exe file ?
>>
>> 2.  Will all the spreadsheet files be untouched ?
>>
>> 3.  If I reload Office 2000 or the excel.exe ,  will lose any add-in's
>> that exist at the moment. not really a problem as I can still reload the
>> add-in
>>
>>  
>>
>> 4. There maybe other options you can suggest.
>>
>>  
>>
>> At about the same time I had downloaded   ASAP Excel utility.  I have now
>> removed from computer. No improvement though with opening Excel.
>>
>>  
>>
>> I have tried to  open Excel in 'safe' mode'  no luck.  Double clicked the
>> .exe file itself, no luck, did a registry clean with ccleaner no luck.   Did
>> a virus scan on critical areas, no luck.
>>
>>  
>>
>> Look forward to receiving good addvice to resolve my problem.
>>
>>  
>>
>> Thanks
>>
>>  
>>
>> Charlie Harris
>>
>> NZ
>>
>>  
>>
>>  
>>
>> --
>>
&

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

[Cab Boose]

Hi Everybody

Thankyou for all your suggestions.

Still no success.  Have tried new 'user',  have reinstalled Office 2000,
have tried changing the settings in IE as per earlier email.

Could it be a file that is causing a problem.  How would I change all the
Excel file extension so that Excel would not recognise any of the files, try
it, and then bring the files back in one by one to see what happens.

Any other ideas would be much appreciatted.

Thanks

Charlie Harris

On Sat, Aug 6, 2011 at 12:34 AM, Rajan_Verma wrote:

>  *Follow The Link For your Answer :*
>
> * *
>
>
> http://answers.microsoft.com/en-us/windows/forum/windows_7-desktop/does-microsoft-word-and-excel-2000-work-on-windows/845d0337-1348-4db3-a123-061c12cb26de
> **
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Friday, August 05, 2011 2:20 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed**
> **
>
> ** **
>
> *Hi **Charlie,*
>
> ** **
>
> *Please try with some Others  UserAccount Logins else Create a New Login
> Account and try...*
>
> ** **
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> ** **
>
> On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose  wrote:
>
> Hi Venkat
>
>  
>
> Thanks for the reference.  I was pretty sure that it would work.
> Unfortuanately no.  I still get the same message.
>
>  
>
> Any other options ?   I am sure we will find it eventually.
>
>  
>
> Thanks
>
>  
>
> Charlie
>
>  
>
>  
>
>  
>
>
>
>  
>
> On Fri, Aug 5, 2011 at 6:19 PM, Venkat CV  wrote:**
> **
>
> Hi,
>
>  
>
> Look below links See if helps...
>
>  
>
>
> http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/
> 
>
>  
>
> ** **
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose  wrote:
>
> Hi
>
>  
>
> I am using Win7 and Excel 2000.
>
>  
>
> Have never had problems for years, but now all of a sudden Excel will not
> open.  Comes up with :   "Windows can not access the specified device, path
> or file."
>
>  
>
> I have been advised to reload Office 2000.  A couple of questions:
>
>  
>
> 1.  Do I reload all of Office 2000 or is it best just to reload the
> excel.exe file ?
>
> 2.  Will all the spreadsheet files be untouched ?
>
> 3.  If I reload Office 2000 or the excel.exe ,  will lose any add-in's that
> exist at the moment. not really a problem as I can still reload the add-in
> 
>
>  
>
> 4. There maybe other options you can suggest.
>
>  
>
> At about the same time I had downloaded   ASAP Excel utility.  I have now
> removed from computer. No improvement though with opening Excel.
>
>  
>
> I have tried to  open Excel in 'safe' mode'  no luck.  Double clicked the
> .exe file itself, no luck, did a registry clean with ccleaner no luck.   Did
> a virus scan on critical areas, no luck.
>
>  
>
> Look forward to receiving good addvice to resolve my problem.
>
>  
>
> Thanks
>
>  
>
> Charlie Harris
>
> NZ
>
>  
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> 
>
> -- 
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for 

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

[Cab Boose]

Hi Venkat

Thanks for the reference.  I was pretty sure that it would work.
Unfortuanately no.  I still get the same message.

Any other options ?   I am sure we will find it eventually.

Thanks

Charlie






On Fri, Aug 5, 2011 at 6:19 PM, Venkat CV  wrote:

> Hi,
>
> Look below links See if helps...
>
>
> http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/
>
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose  wrote:
>
>> Hi
>>
>> I am using Win7 and Excel 2000.
>>
>> Have never had problems for years, but now all of a sudden Excel will not
>> open.  Comes up with :   "Windows can not access the specified device, path
>> or file."
>>
>> I have been advised to reload Office 2000.  A couple of questions:
>>
>> 1.  Do I reload all of Office 2000 or is it best just to reload the
>> excel.exe file ?
>> 2.  Will all the spreadsheet files be untouched ?
>> 3.  If I reload Office 2000 or the excel.exe ,  will lose any add-in's
>> that exist at the moment. not really a problem as I can still reload the
>> add-in
>>
>> 4. There maybe other options you can suggest.
>>
>> At about the same time I had downloaded   ASAP Excel utility.  I have now
>> removed from computer. No improvement though with opening Excel.
>>
>> I have tried to  open Excel in 'safe' mode'  no luck.  Double clicked the
>> .exe file itself, no luck, did a registry clean with ccleaner no luck.   Did
>> a virus scan on critical areas, no luck.
>>
>> Look forward to receiving good addvice to resolve my problem.
>>
>> Thanks
>>
>> Charlie Harris
>> NZ
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>  **
> *
> **
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel 2000 will not Open - Advice needed

[Cab Boose]

Hi

I am using Win7 and Excel 2000.

Have never had problems for years, but now all of a sudden Excel will not
open.  Comes up with :   "Windows can not access the specified device, path
or file."

I have been advised to reload Office 2000.  A couple of questions:

1.  Do I reload all of Office 2000 or is it best just to reload the
excel.exe file ?
2.  Will all the spreadsheet files be untouched ?
3.  If I reload Office 2000 or the excel.exe ,  will lose any add-in's that
exist at the moment. not really a problem as I can still reload the add-in

4. There maybe other options you can suggest.

At about the same time I had downloaded   ASAP Excel utility.  I have now
removed from computer. No improvement though with opening Excel.

I have tried to  open Excel in 'safe' mode'  no luck.  Double clicked the
.exe file itself, no luck, did a registry clean with ccleaner no luck.   Did
a virus scan on critical areas, no luck.

Look forward to receiving good addvice to resolve my problem.

Thanks

Charlie Harris
NZ

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

[Cab Boose]

Hi

Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet in
one click.  Magic.

Charlie







On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote:

>
>
>  Dear Vijay,
>
> Please find Error remover technique.
>
>   * Errors-World* Error Type
> Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
> IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
> YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
> #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
>  # Press Alt+O+C+A  2.32335E+16 Press
> Ctrl+1,Custom Format->Press 0  Circular Reference Formula-Error
> checking-Select Circular Reference and Decreas formula Range
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>
>
> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi,
>>
>>
>> I have one questions.Usually while doing reports what are errors you will
>> get ?
>>
>>
>> Thanks
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ VBA Macro with Input Box

[Cab Boose]

Hi

Where can I find some good info on :

When a macro runs I want a input box for user to insert the column range
A:(or B; or F: etc) and then a input box for the text to look for say
ABC or 123 or xyz etc and then a third box for the column for a format to be
done.

Have googled but have not found anything.

Let me know of a suitable site and I can try and adapt code

Thank you

Charlie

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Data Input Sheet - Deleting Entries - all added data deletes

[Cab Boose]

Hi Ashish

Thanks for that.  How do I toggle the 'TabOrder' on ?  At the moment the tab
order is not working.

Thanks

Charlie

On Thu, Jul 21, 2011 at 7:08 PM, ashish koul  wrote:

> try this
>
>
> On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose  wrote:
>
>> Hi Rajan
>>
>>
>>
>> I have attached copy of the sheet involved.
>>
>>
>> Let me know what you think.
>>
>> Thanks
>>
>> Charlie
>>
>>   On Wed, Jul 20, 2011 at 9:19 PM, Rajan_Verma 
>> wrote:
>>
>>>  *Would you please attached Workbook.*
>>>
>>> * *
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
>>> *Sent:* Wednesday, July 20, 2011 2:10 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Data Input Sheet - Deleting Entries - all
>>> added data deletes
>>>
>>> ** **
>>>
>>> Hi everyone
>>>
>>>  
>>>
>>> Excel 2000 Win7
>>>
>>>  
>>>
>>> I am using code below to enter data onto a sheet.  The sheet works well
>>> in entering data, but when you go back to an entry above and delete the
>>> current data and put in the correct data, on the delete key it deletes all
>>> data entered and user has to start over again.
>>>
>>>  
>>>
>>> How to stop all data entered being deleted ?:
>>>
>>>  
>>>
>>> Thanks
>>>
>>>  
>>>
>>> Charlie
>>>
>>>  
>>>
>>>  
>>>
>>> **
>>>
>>>  
>>>
>>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>> 'Establishes tab order for data entry. Hit Enter or Tab keys to jump to
>>> the next cell.
>>>
>>> Dim TabOrder As Variant, X As Variant
>>> Dim addr As String
>>> Dim rg As Range, targ As Range
>>> If TabOrderFlag = True Then Exit Sub
>>>
>>> TabOrder = Array("h8", "h9", "h10", "h11", "h13", "l11", "l12", "h17",
>>> "k17", "h18", "k18", "k21", "k22", "n26", "n27", "n31", _
>>> "k37", "e82", "f82", "h82", "j82", "e83", "f83", "h83", "j83", "e84",
>>> "f84", "h84", "j84", "e85", "f85", "h85", _
>>> "j85", "e86", "f86", "h86", "j86", "e87", "f87", "h87", "j87", "e88",
>>> "f88", "h88", "j88", "e89", "f89", _
>>> "h89", "j89")
>>>
>>> 'List your cell addresses in desired tab order here
>>> For Each X In TabOrder
>>> If rg Is Nothing Then
>>> Set rg = Range(X)
>>> Else
>>> Set rg = Union(rg, Range(X))
>>> End If
>>> Next
>>>
>>> Set targ = Intersect(rg, Target)
>>> rg.Select
>>> If targ Is Nothing Then
>>> addr = Target.Cells(1, 1).Address(ColumnAbsolute:=False,
>>> RowAbsolute:=False)
>>> X = Application.Match(addr, TabOrder, 0)
>>> If IsError(X) Then Range(TabOrder(LBound(TabOrder))).Activate
>>> Else
>>> targ.Activate
>>> End If
>>>
>>> End Sub 
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow belo

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

[Cab Boose]

Hi Daniel

Works perfect.  I am very pleased with your help.

Regards

Charlie

On Wed, Jul 20, 2011 at 10:04 PM, Daniel  wrote:

> My last effort ; see attached file.
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 22:56
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel
>
>  
>
> Sorry to say, still doing the same thing.
>
> I am using  Excel2000 and Win7.
>
>  
>
> Appreciate yur comments.
>
>  
>
> Thankyou
>
>  
>
> Charlie
>
> On Tue, Jul 19, 2011 at 10:37 PM, Daniel  wrote:
>
> Sorry. Hope this one is better.
>
>  
>
> Daniel****
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 06:27
>
>
> *À :* excel-macros@googlegroups.com
>
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
>  
>
> Hi Daniel
>
>  
>
> Thanks for a great result.  Not quite there yet.  When double click the
> comment box doubles it size.  When cursor is moved away from that cell and
> then back to that cell the double size is still there sometimes.  Sometimes
> it does go back to normal but not all the time.  
>
>  
>
> So when the comments has been double clicked and then closed by moving the
> cursor, when looking at that comments again it should be normal size.
>
>  
>
> Hope I  have explained well.
>
>  
>
> Thankyou
>
>  
>
>  
>
> Charlie
>
> On Mon, Jul 18, 2011 at 10:27 PM, Daniel  wrote:
>
> Hi,
>
> Have alook at the attached workbook.
>
> You need a standard module where you paste :
>
>  
>
> Public Res As String
>
>  
>
> In the sheet module, paste :
>
>  
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
> If Intersect(ActiveSheet.Cells.SpecialCells(xlCellTypeComments), Target) _
> 
>
> Is Nothing Then Exit Sub
>
> Cancel = True
>
> If Res <> "" Then
>
> With Range(Res).Comment.Shape
>
> .Height = .Height / 2
>
> .Width = .Width / 2
>
> End With
>
> End If
>
> Res = Target.Address
>
> With Target.Comment.Shape
>
> .Height = .Height * 2
>
> .Width = .Width * 2
>
> End With
>
> End Sub
>
>  
>
> Regards.
>
> Daniel
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* lundi 18 juillet 2011 09:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
>  
>
> Hi Ashish and all
>
>  
>
> I have a spreadsheet (thanks to Ashish) that uses comments boxes.  The size
> of the box is great.  But on some occassions the user will want to see a
> larger box.  I know it can be increased thru edit and resize etc but is
> there a way to say have a right click where the size  could double.  When
> finished and user goes to another box the box size returns to standard.***
> *
>
> Another option may be to have a shortcut key to double the size of active
> comments box, return to standard size when finished.
>
> Have Googled with no luck.
>
>  
>
>  
>
> Thankyou everyone
>
>  
>
> Charlie Harris
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://w

$$Excel-Macros$$ Data Input Sheet - Deleting Entries - all added data deletes

[Cab Boose]

Hi everyone

Excel 2000 Win7

I am using code below to enter data onto a sheet.  The sheet works well in
entering data, but when you go back to an entry above and delete the current
data and put in the correct data, on the delete key it deletes all data
entered and user has to start over again.

How to stop all data entered being deleted ?:

Thanks

Charlie


**

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Establishes tab order for data entry. Hit Enter or Tab keys to jump to the
next cell.

Dim TabOrder As Variant, X As Variant
Dim addr As String
Dim rg As Range, targ As Range
If TabOrderFlag = True Then Exit Sub

TabOrder = Array("h8", "h9", "h10", "h11", "h13", "l11", "l12", "h17",
"k17", "h18", "k18", "k21", "k22", "n26", "n27", "n31", _
"k37", "e82", "f82", "h82", "j82", "e83", "f83", "h83", "j83", "e84", "f84",
"h84", "j84", "e85", "f85", "h85", _
"j85", "e86", "f86", "h86", "j86", "e87", "f87", "h87", "j87", "e88", "f88",
"h88", "j88", "e89", "f89", _
"h89", "j89")

'List your cell addresses in desired tab order here
For Each X In TabOrder
If rg Is Nothing Then
Set rg = Range(X)
Else
Set rg = Union(rg, Range(X))
End If
Next

Set targ = Intersect(rg, Target)
rg.Select
If targ Is Nothing Then
addr = Target.Cells(1, 1).Address(ColumnAbsolute:=False, RowAbsolute:=False)
X = Application.Match(addr, TabOrder, 0)
If IsError(X) Then Range(TabOrder(LBound(TabOrder))).Activate
Else
targ.Activate
End If

End Sub

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

[Cab Boose]

Hi Daniel

Sorry to say, still doing the same thing.
I am using  Excel2000 and Win7.

Appreciate yur comments.

Thankyou

Charlie

On Tue, Jul 19, 2011 at 10:37 PM, Daniel  wrote:

> Sorry. Hope this one is better.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 06:27
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel
>
>  
>
> Thanks for a great result.  Not quite there yet.  When double click the
> comment box doubles it size.  When cursor is moved away from that cell and
> then back to that cell the double size is still there sometimes.  Sometimes
> it does go back to normal but not all the time.  
>
>  
>
> So when the comments has been double clicked and then closed by moving the
> cursor, when looking at that comments again it should be normal size.
>
>  
>
> Hope I  have explained well.
>
>  
>
> Thankyou
>
>  
>
>  
>
> Charlie
>
> On Mon, Jul 18, 2011 at 10:27 PM, Daniel  wrote:
>
> Hi,
>
> Have alook at the attached workbook.
>
> You need a standard module where you paste :
>
>  
>
> Public Res As String
>
>  
>
> In the sheet module, paste :
>
>  
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
> If Intersect(ActiveSheet.Cells.SpecialCells(xlCellTypeComments), Target) _
> 
>
> Is Nothing Then Exit Sub
>
> Cancel = True
>
> If Res <> "" Then
>
> With Range(Res).Comment.Shape
>
> .Height = .Height / 2
>
> .Width = .Width / 2
>
> End With
>
> End If
>
> Res = Target.Address
>
> With Target.Comment.Shape
>
> .Height = .Height * 2
>
> .Width = .Width * 2
>
> End With
>
> End Sub
>
>  
>
> Regards.
>
> Daniel
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* lundi 18 juillet 2011 09:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
>  
>
> Hi Ashish and all
>
>  
>
> I have a spreadsheet (thanks to Ashish) that uses comments boxes.  The size
> of the box is great.  But on some occassions the user will want to see a
> larger box.  I know it can be increased thru edit and resize etc but is
> there a way to say have a right click where the size  could double.  When
> finished and user goes to another box the box size returns to standard.***
> *
>
> Another option may be to have a shortcut key to double the size of active
> comments box, return to standard size when finished.
>
> Have Googled with no luck.
>
>  
>
>  
>
> Thankyou everyone
>
>  
>
> Charlie Harris
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

[Cab Boose]

Hi Daniel

Thanks for a great result.  Not quite there yet.  When double click the
comment box doubles it size.  When cursor is moved away from that cell and
then back to that cell the double size is still there sometimes.  Sometimes
it does go back to normal but not all the time.

So when the comments has been double clicked and then closed by moving the
cursor, when looking at that comments again it should be normal size.

Hope I  have explained well.

Thankyou


Charlie

On Mon, Jul 18, 2011 at 10:27 PM, Daniel  wrote:

> Hi,
>
> Have alook at the attached workbook.
>
> You need a standard module where you paste :
>
> ** **
>
> Public Res As String
>
> ** **
>
> In the sheet module, paste :
>
> ** **
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
> If Intersect(ActiveSheet.Cells.SpecialCells(xlCellTypeComments), Target) _
> 
>
> Is Nothing Then Exit Sub
>
> Cancel = True
>
> If Res <> "" Then
>
> With Range(Res).Comment.Shape
>
> .Height = .Height / 2
>
> .Width = .Width / 2
>
> End With
>
> End If
>
> Res = Target.Address
>
> With Target.Comment.Shape
>
> .Height = .Height * 2
>
> .Width = .Width * 2
>
> End With
>
> End Sub****
>
> ** **
>
> Regards.
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* lundi 18 juillet 2011 09:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Ashish and all
>
>  
>
> I have a spreadsheet (thanks to Ashish) that uses comments boxes.  The size
> of the box is great.  But on some occassions the user will want to see a
> larger box.  I know it can be increased thru edit and resize etc but is
> there a way to say have a right click where the size  could double.  When
> finished and user goes to another box the box size returns to standard.***
> *
>
> Another option may be to have a shortcut key to double the size of active
> comments box, return to standard size when finished.
>
> Have Googled with no luck.
>
>  
>
>  
>
> Thankyou everyone
>
>  
>
> Charlie Harris
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Comments Boxes - Temporary Zoom In

[Cab Boose]

Hi Ashish and all

I have a spreadsheet (thanks to Ashish) that uses comments boxes.  The size
of the box is great.  But on some occassions the user will want to see a
larger box.  I know it can be increased thru edit and resize etc but is
there a way to say have a right click where the size  could double.  When
finished and user goes to another box the box size returns to standard.
Another option may be to have a shortcut key to double the size of active
comments box, return to standard size when finished.
Have Googled with no luck.


Thankyou everyone

Charlie Harris

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

[Cab Boose]

Hi Ashish

Thanks for tht.  However it is not what I need.  It is great for the photo
selection and I will use it for that.  What I want here is to copy the
Comments Box thru to another sheet.

Daniels code appears to be exactly what I want but a small error at the
moment.  If I can get Daniels code to work that would be great.
Thankyou

Charlie

On Tue, Jul 12, 2011 at 4:08 PM, ashish koul  wrote:

>
> try this attachment
>
> run the macro it will open  dialog box and choose the database file
>
>
>
>
> On Thu, Jul 7, 2011 at 3:17 PM, Daniel  wrote:
>
>> Hello :
>>
>> ** **
>>
>> Note that the macro should be in the Shipment-New.xls workbook :
>>
>> ** **
>>
>> Sub CopyComments()
>>
>> Dim Rg As Range, C As Comment
>>
>> Dim Sh As Worksheet, x As Range
>>
>> Set Sh = Workbooks("Database.xls").Sheets("Sheet1")
>>
>> With Sheets("Sheet1")
>>
>> For Each Rg In .Range(.[J12], .Cells(.Rows.Count, 10).End(xlUp))
>>
>> Set x = Sh.[J:J].Find(Rg.Value, , , xlWhole)
>>
>> If Not x Is Nothing Then
>>
>> Set Var = x.Offset(, 1)
>>
>> x.Offset(, 1).Copy
>>
>> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments
>>
>> End If
>>
>> Next Rg
>>
>> End With
>>
>> End Sub
>>
>> ** **
>>
>> Regards.
>>
>> Daniel
>>
>> ** **
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* Cab Boose
>> *Envoyé :* jeudi 7 juillet 2011 08:56
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ VBA Comment Box - Copy of
>>
>> ** **
>>
>> Hi 
>>
>> Have a photo in a comments  box in Database.xls.  Also have a vlookup in
>> another workbook Shipment-New.xls  to bring forward the text from the cell
>> into
>> the wb.  This works great.  I also want to bring forward the comment box
>> in the same cell from Database.xls  into Shipment-New.xls. 
>>
>> Would like to use vlookup function but I believe not possible.  Is a
>> vba event better, and  do I use vba copy/paste special  macro, or is there
>> a better
>> method. 
>>
>> Thanks 
>>
>> Charlie 
>>
>>
>> 
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think a

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

[Cab Boose]

Hi

Is someone able to comment on my problem as below.  Tried to contact Daniel
with no luck.

Thankyou

Charlie Harris

On Fri, Jul 8, 2011 at 1:13 PM, Cab Boose  wrote:

> Hi Daniel
>
> Thanks for code.  Have done as you suggest and installed in the Shipments
> wb.  When I run the code it goies thru to   var =...   and gives a
> message that ' variable not defined '  .
>
> Is there something missding ?
>
> Your help appreciated.
>
> Thanks
>
> Charlie
>
> On Fri, Jul 8, 2011 at 3:33 AM, ashish koul  wrote:
>
>> try this attachment
>>
>> run the macro it will open  dialog box and choose the database file
>>
>>
>>
>>
>> On Thu, Jul 7, 2011 at 3:17 PM, Daniel  wrote:
>>
>>>  Hello :
>>>
>>> ** **
>>>
>>> Note that the macro should be in the Shipment-New.xls workbook :
>>>
>>> ** **
>>>
>>> Sub CopyComments()
>>>
>>> Dim Rg As Range, C As Comment
>>>
>>> Dim Sh As Worksheet, x As Range
>>>
>>> Set Sh = Workbooks("Database.xls").Sheets("Sheet1")
>>>
>>> With Sheets("Sheet1")
>>>
>>> For Each Rg In .Range(.[J12], .Cells(.Rows.Count, 10).End(xlUp))
>>>
>>> Set x = Sh.[J:J].Find(Rg.Value, , , xlWhole)
>>>
>>> If Not x Is Nothing Then
>>>
>>> Set Var = x.Offset(, 1)
>>>
>>> x.Offset(, 1).Copy
>>>
>>> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments
>>>
>>> End If
>>>
>>> Next Rg
>>>
>>> End With
>>>
>>> End Sub
>>>
>>> ** **
>>>
>>> Regards.
>>>
>>> Daniel
>>>
>>> ** **
>>>
>>> *De :* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *De la part de* Cab Boose
>>> *Envoyé :* jeudi 7 juillet 2011 08:56
>>> *À :* excel-macros@googlegroups.com
>>> *Objet :* $$Excel-Macros$$ VBA Comment Box - Copy of
>>>
>>> ** **
>>>
>>> Hi 
>>>
>>> Have a photo in a comments  box in Database.xls.  Also have a vlookup in
>>> another workbook Shipment-New.xls  to bring forward the text from the
>>> cell into
>>> the wb.  This works great.  I also want to bring forward the comment box
>>> in the same cell from Database.xls  into Shipment-New.xls. 
>>>
>>> Would like to use vlookup function but I believe not possible.  Is a
>>> vba event better, and  do I use vba copy/paste special  macro, or is
>>> there a better
>>> method. 
>>>
>>> Thanks 
>>>
>>> Charlie 
>>>
>>>
>>> 
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

[Cab Boose]

Hi Daniel

Thanks for code.  Have done as you suggest and installed in the Shipments
wb.  When I run the code it goies thru to   var =...   and gives a
message that ' variable not defined '  .

Is there something missding ?

Your help appreciated.

Thanks

Charlie

On Fri, Jul 8, 2011 at 3:33 AM, ashish koul  wrote:

> try this attachment
>
> run the macro it will open  dialog box and choose the database file
>
>
>
>
> On Thu, Jul 7, 2011 at 3:17 PM, Daniel  wrote:
>
>>  Hello :
>>
>> ** **
>>
>> Note that the macro should be in the Shipment-New.xls workbook :
>>
>> ** **
>>
>> Sub CopyComments()
>>
>> Dim Rg As Range, C As Comment
>>
>> Dim Sh As Worksheet, x As Range
>>
>> Set Sh = Workbooks("Database.xls").Sheets("Sheet1")
>>
>> With Sheets("Sheet1")
>>
>> For Each Rg In .Range(.[J12], .Cells(.Rows.Count, 10).End(xlUp))
>>
>> Set x = Sh.[J:J].Find(Rg.Value, , , xlWhole)
>>
>> If Not x Is Nothing Then
>>
>> Set Var = x.Offset(, 1)
>>
>> x.Offset(, 1).Copy
>>
>> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments
>>
>> End If
>>
>> Next Rg
>>
>> End With
>>
>> End Sub
>>
>> ** **
>>
>> Regards.
>>
>> Daniel
>>
>> ** **
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* Cab Boose
>> *Envoyé :* jeudi 7 juillet 2011 08:56
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ VBA Comment Box - Copy of
>>
>> ** **
>>
>> Hi 
>>
>> Have a photo in a comments  box in Database.xls.  Also have a vlookup in
>> another workbook Shipment-New.xls  to bring forward the text from the cell
>> into
>> the wb.  This works great.  I also want to bring forward the comment box
>> in the same cell from Database.xls  into Shipment-New.xls. 
>>
>> Would like to use vlookup function but I believe not possible.  Is a
>> vba event better, and  do I use vba copy/paste special  macro, or is there
>> a better
>> method. 
>>
>> Thanks 
>>
>> Charlie 
>>
>>
>> 
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
>   --
>
> 

$$Excel-Macros$$ VBA Comment Box - Copy of

[Cab Boose]

 Hi

Have a photo in a comments  box in Database.xls.  Also have a vlookup in
another workbook Shipment-New.xls  to bring forward the text from the cell
into
the wb.  This works great.  I also want to bring forward the comment box
in the same cell from Database.xls  into Shipment-New.xls.

Would like to use vlookup function but I believe not possible.  Is a
vba event better, and  do I use vba copy/paste special  macro, or is there a
better
method.

Thanks

Charlie

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Database.xls
Description: MS-Excel spreadsheet


Shipment-New.xls
Description: MS-Excel spreadsheet