Search results for query: *

I was trying to find a way of copying a cell's value and strikethrough. However, when only part of the text is strikethrough then it gets trickier. So i wrote this in order to just spot the characters that are "strikethrough-ed". If anyone knows of a better way to copy only the strikethrough...

Whenever someone sends me a GIF or a JPEG, by default, it opens in Microsoft Photo Editor. What would I need to do to open it in Internet Explorer by default. Thanks!

Is it possible, that when you 'autofilter' a list, that somehow you can get each individual item in the list. For example, if i have a column full of Last Names, i want each different name, sort of what it looks like when you use the drop down menu to filter. thanks

The help files dont seem to help, but is there anyway...through code...to make a Reference to "Microsoft Visual Basic for Applications Extensiblity 5.3" Library. I wouldn't want to go to each machine using my code and manually setting the Reference. Thanks

I doubt this is possible, but is there a way to compare that a range of cells are identical in everywhere to another set of ranges such as Range("A1:A3") and Range("B1:B3") so i can spot any differences, even in formatting i tried using the "=" but that didnt work, if not possible...what is the...

When using the Worksheet change event, Is there anyway that you can limit the event to absolute or relative ranges instead of the whole sheet? For example, if certain data is entered in column A, then it is checked for certain formatting..but the data in Column B is checked for another...

is there anyway I can map to a network drive, where i can input the username and password? thanks

I hope its possible, but basically ill have an array of about 5 different strings. I want to use .find method ONCE to find what cell they are in, in my worksheet. How do I bind that cell address to the string whenever that string comes up again, so I wont use the .find method again. I can...

Im debating the best way to determine whether the strings in numerous cells of one column can be compared with strings in another column. Column A has cells with strings that contain many blank characters Column B has basically those same string but without the blank characters For example: A...

If i declare a variable in one sub, but i want to pass it to another sub that I call, do i still have to declare the type of the variable like this: sub a() dim b as string call c(b) end sub sub c(b as string) 'Is this declaration still needed?? end sub if i leave it as subc(b), would that...

I have an addin that creates a menu. when you select a menu item it executes code that is also stored in the add-in...however there is a problem if the addin sub has the same name as a macro in the activeworkbook. I have tried to get around this but cant, when i create the menu i say .onaction...

I have a CD that has a database that is in .DAT format, if i open it in access it says not recognizable, is there anyway i can convert it to a recognizable format, thanks??

is there a simpler alternative to for each ws in worksheets if ws.visible = true then .... next is there something sort of equivalent to for each ws in worksheets.hidden next OR for each ws.hidden in worksheets next thanks

vb doesnt seem to allow me to search for comments in individual columns, only on the entire worksheet is there anyway where i can essentially write for each cmt in [A:A].comments ... next

Hi, Im trying to mess around with the protection properties of Excel 2000, and I cant seem to find a way to protect formatting in a spreadsheet. The closest I got was to unlock everything and then protect the worksheet, which still allowed me to edit text and keep my formatting. But it didn't...

Hi, Im trying to mess around with the protection properties of Excel, and I cant seem to find a way to protect formatting in a spreadsheet. The closest I got was to unlock everything and then protect the worksheet, which still allowed me to edit text and keep my formatting. But it didn't allow...

I know that the memoryused property tells us how much memory excel has used, but is there anyway to bring that to a smaller scaleand see how much memory is being allocated to a variable, or collection, or data type, or anything like that, thanks!

when i try to send an email with a macro, it wont let me because it alerts me that a virus could be sending the message for me, and it says theonly way that i can send it without this alert is if i publish it in a form....what exactly does this mean? thanks

is there a way i can find some properties of a range i define, such as set myrange = workbooks("xxx").worksheets("yyy")... so that later on in my program if i just have myrange, can i find out what workbook and what worksheet it is in? thanks!

is it just in my office, or do some workbooks have a worksheet named "xxxxxx" as the first worksheet. Ive seen this on some files, and its invisible...its not a major bother, but im curious if someone has seen this before, why do some files have it