Search results for query: *

Nice, I didnt know that you could use a 'PasteRange' in that manner. I'll see how it works out for me.

well I figure i would first make the value of the target cell equal to the value of the activecell, then simply make the ith character of both cells match strikethroughs

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!

ok thank you very much, ill probably keep it safe and not tamper too much with it, but it's always cool to know more stuff

My Apologies VBAjedi, everything worked out fine, but one more question, is there anyway to sort of perform the autofilter just in code as opposed to actually doing it on the spreadsheet, so if i just want to work with the values associated with the values in one column

unfortunately i dont have that option in the drop down list....and even if i did...if i use something like activecell.offset(1,0) wouldnt that select the next cell down, regardless of what's on the screen

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

UU very nice....actually just before you responded I was able to rearrange my code so that I wouldn't have to make that reference....the only weird thing i cant explain is that although the code works, i cannot specify the declaration I want Dim VBComp as VBComponents...gives me an error...

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

out of curiosity, what is inventor?

oh well my familiarity is only with Excel, but im thinking that would work with all office application....maybe it only works with office applications, and not one that you define yourself my last resort would be to use inventor.application.displayalerts = false if that doesnt work, sorry.

that is the version i have, so i would go along and test InvApp.application.displayalerts = false or simply application.displayalerts = false

what version of VBA are you using?

when i do it i put the actual words application.displayalerts = false or you could put Excel.application.displayalerts = false if your using Excel and you want to put the application's name there....so i think for your purposes you could maybe try InvApp.application.displayalerts = false

oh i forgot to mention, that line must be in your code, it wont work if you do it seperatly, becuase after code is executed, it defaults back to true, so i suggest putting that perhaps in the beginning of your code and then set it to true if you need to display certain messages.

well i apologize, i mispelled it, it should be Application.DisplayAlerts = False if that doesnt work,,,then I dont know what else will.

hmm...do you know if in the help or somewhere there is a complete list of formatting properties, not just color? thanks!!!

try, application.displayalters = false

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...