Hello Have you ever thought of you as a Computer Scientist contributing to flourish music and get benefited? And how if my second conjecture is that a person...

Suppose I want to select a specific range, such as: Range("B10:Q10").Select The above range exists on row #10, between Column B and Column Q. In...

Hi, i'm new to VBA coding. The situation is that I have a file that comes in every week with the same number of column, but with different number of rows . I...

Hello all, So I have a sheet within a workbook that I am wanting to save/publish as a PDF file. the code i have thus far is : Sub Publish2() ' ' Publish2...

This might be a dumb question, but here goes.... If I run this code: Range("A12:M2").Select is there a command that will "undo" or cancel...

Hi Got a cash sheet and want to put names addresses and email addresses of people in it but by the time I've got a column for each of these (the address...

Is this the only way to determine if a userform is visible? : if (Userform.Visible = true) then ' code here end if The problem with this code is...

With a list of names in column A, this code will add a sheet and name it from that list. If I add a few names to the list, how can I ignore the names with...

I run Excel 2003 and VBA 6.5. I have a very limited understanding of VBA's Range object. I hit this on a sheet which has relevant formulae in column C. I...

Hi, Is it possible to test, if a function (UDF) is called from a worksheet (as a normal worksheet function) or from another macro/VBA code? Thanks, CE

Hi, i am using a find action to find a specific value in a multi column list. i can find the value no probs and can return the cell reference the valueis...

Large spreedsheet that I want to save my start line. step down 1 line and delete 29 line. Step down 1 line and delete 29 lines. Basicaly I want to save every...

I have a report that contains merged cells. I need to get rid of the merged cells and then have the data from the first row repeated in the blank rows. I...

How do web queries work? Where is the documentation? (I don't have excel here and will use it elsewhere) - = - Vasos Panagiotopoulos,...

Hello All, I have 7 pictures on one worksheet that I want to copy and paste on to another worksheet, into various cells. Each image will go into only one...

Hi,i am new to macro coding,i have to browse thru a directory and sub folders get the names of 2 files,and get the names of sheets from each file one by...

This is a shortened list of sounds in column R, sheet 1. And is the list for a data validation drop down in...

Hi, Under the workbook properties tab, there's a checkmark called 'Save preview picture'. How to read/set this setting by VBA code? Thanks,

This has been floating around for a while now, but I gave it a serious reworking. Option Explicit Public Sub AllInternalPasswords() On Error Resume Next ' '...

I have developed a addin successfully. I need to restrict its usage on one pc only. I am aware that I can not fully stop piracy but still I like to have...