Search:

Hi,
I have an Excel spreadsheet with my merge data and have a Word document set up to merge the data from my Excel spreadsheet. I use the following code to control this merge from Excel which works...

I have a C and D partitioned drive. I wish to create an E partition as I need to restore files from an E drive. However when I create another partition in Windows, it assigns the letter I.

Is...

My kids play their music through the computer inbuilt speaker as it doesn't have stereo speakers. However they play it far too loud and I'm concerned that they'll do permanent damage to the speaker....

Thanks for the tips, RG - as a self taught coder, there are many things I can learn!

Just about got it now, have replaced

ActiveCell.EntireRow.Select

with

Rows(lngrow).EntireRow.Select

OK I've nearly got it but even though the code seems to me to be logically correct it sometimes returns the wrong results and never seems to highlight the entire row.
The idea is this - the user...

Apologies - I have included the code in the attached file - the first thing it does is open the file to compare and I made a start on the code but figured there must be a better method than the one I...

I need to do a loop within a loop within a loop as follows:
I want to compare two files and highlight the new rows and cells in the latest file, as follows:
On the enclosed spreadsheet, I click on...

Thanks noel, I downloaded Attibute Changer and it works on every folder - except the walkman! Any other thoughts anyone?

I wish to change my file attributes from read-only to write so I can delete the files but in Explorer they are greyed out - how can I do this? Please see the screen capture to illustrate.

Thnaks...

Sorry, it should read column E not column D - "suppliers in column E. I have code that assigns, say, "TOFS" to the variable msgin. I want the code to find if the text "TOFS" occurs in the cell in...

The enclosed spreadsheet has suppliers in column D. I have code that assigns, say, "TOFS" to the variable msgin. I want the code to find if the text "TOFS" occurs in the cell in column D and if it...

Brilliant, thanks very much, greatly appreciated.

In the enclosed spreadsheet I want a macro to go through the list in columns A to D, search for each item in cells J8 to J13 and replace found items with the corresponding item in cells K8 to K13.
...

Hi Hans, I feel a bit foolish however I've noticed that the cells are text, not a formula. They have been Range->Valued

However in this instance I would have thought that my formula stated earlier...

Thanks Hans, but there are cells with errors in them per the enclosed screen shot. They will always be at the end of the spreadsheet, so perhaps another method would be better?

Thanks Hans, but I still get the same 'no cells found' error. When I hover the mouse over the variables, they read:

msgin = v1:v793 'correct
xlCellTypeformulas = -4123 'is this...

Thanks Jan,

In order to modify your code for my situation, I've created the following:


'First of all, determine the range, how far down the formulas go
Dim lngRow As Long, lngMaxRow As Long,...

Hi, after doing a range/value command, I want to remove rows where #DIV/0! appears in column V. I have tried the following but I get a mismatch error:

'Get rid of #DIV/0! errors
Dim lngRow As...

SOLVED!!!!

Finally after much angst I have solved the issue.

The problem was caused by:
1. The manual saying I could access the Print Server at the address 192.168.0.10 - wrong. My router...

You have given your Print Server a fixed IP address of 192.168.0.10
The same IP address is within the range that your DHCP server will hand out.

This is probably not the cause of your current...

Hi Batcher,

Fixed IP of print server = 192.168.0.10


Below see the results of ipconfig /all:

Windows IP Configuration

Host Name . . . . . . . . . . . . : Dad

Thanks for the post, Batcher, but yes I am working through the guide. It doesn't show up on 'My Network Places' either.

btw I have Zone Alarm which I have turned off.

I am assuming that when...

Hi,

I'm using Windows XP and have a DLink 524 Router. I just bought a DLink DPR-1260 Print Server but I cannot display the interface. When I type in the URL I just get a 'Page cannot be displayed'...

Hans - thanks for the code tip - works perfectly.

StuartR - thanks for the explanation, makes sense and was exactly the problem.

Cheers,
Tedoz

I use the following code to save a new workbook with a new name into the same directory:

dirf = ActiveWorkbook.Path
ChDir (dirf)

fname = Range("F_Order").Value
ActiveWorkbook.SaveAs...