Search results for query: *

Hi dcompto, I think there is a slight misunderstanding here. I do not want to skip the hidden cells while copying but when I am pasting. I think that the procedure that you suggested works when you want to skip hidden cells before you copy a range containing those hidden cells. But what I...

Hi all, I need some help regarding an issue that I have run into. Say I have copied a range of cells and I want to paste it in another range but the catch is: I might have some hidden rows in the destination range and I want to skip those hidden rows when pasting this data. Is it possible to...

Hi Mr. Dodge, Thanks for your reply. I do know VBA, but I still dont know how to do what I want to do. I tried your suggestion on the spread sheet side and it did give me an error saying that the copy area and the paste area are not the same (and it did not paste the data). But actually I will...

Hi all, I need some help regarding an issue that I have run into. Say I have copied a range of cells and I want to paste it in another range but the catch is: Is it possible to skip some hidden rows in the destination range when pasting the copied data. I tried looking at the paste special...

Hi Andrea, Thanks for you suggestion. Now it seems to be working. I created an empty sheet with the same name as my source sheet (so the links refer to an existing sheet and as a result the cells contain the default values) and then based on the user inputs, I am just copying the generated...

Hi Dale, Thank you for your response. Your suggestion (about named ranges) would have been great except for the fact that there are so many cells that I would have to name and set the links to, it would practically be difficult. And about creating the sheet beforehand and keeping it hidden, the...

Hi everybody, I need some help regarding a problem that I have. I have a Excel workbook that has some cells of a sheet linked to some other cells of another sheet (both sheets belong to the same workbook). Now, to begin with, the source sheet (for the links) does not exist (so Excel gives me...

Thanks guys, I think I will use the If/Else structure after all as suggested by Jooky68. I also agree with Zathras about programming practice. Thanks once again. Shahnaz.

Hi everybody, I have a strage problem. I have a Do...While loop. I was wondering if there is anything in VBA similar to the CONTINUE instruction in JAVA or C++ so that I can go back to the beginning of the Do loop midway through the loop without executing the rest of the code based on some...

Hi John, Thanks a lot again. I will be back....... Good day, Shahnaz.

Hi John, Thanks very much. It worked. Now the macro runs fine and prints out the results. Also I incorporated your suggestions about MoveNext and Closing the record set. Thanks once again. I would really be grateful if you could also tell me how to check to see if we have a successful...

Hi everyone, I am new to VB/VBA so kindly bear with me if my question sounds naive. I am trying to connect to a Access 2002 Database from an Excel 2002 worksheet macro. I think I am able to open the database fine, but when I try to create a QueryDef object in order to run some queries, I keep...