Search results

Hello everyone, I am looking to merge two workbooks where both has its own macros and such. Is there a way to do it? Thanks, Hema

Hi Shrivallabha, I am attaching the workbook in this response. Initially I had the above code under Private Sub Worksheet_Change(ByVal Target As Range) along with the other codes, however that slowed down the executing of the workbook tremendously. I was told not to place it under there since...

I am trying to hide multiple rows in multiple worksheets in the same workbook, but the formula is not working... I think it has to do with the first line. Above this code, I have Worksheet_Change(ByVal Target As Range) for other codes. Thank you so much in advance! Private Sub...

Thank you so much Narayan. One portion of your code worked for me and I derived the rest for the sheets. - A little slow, but better than nothing! Thank you again! The code I landed up using is : Application.ScreenUpdating = False For Each c In Worksheets("FlatStage").Range("A7:A32") If...

Narayan, The other lines needs to remain, the code that is not working is on the very last section on PDData sheet.

Narayan, What I am trying to do is to hide the empty rows in FlatStage A7:A32 when those rows are empty and when it is not, it needs to display the data. The workbook you sent back to me doesn't seem to be able to do that. Yes I meant the Worksheet_Change procedure :)

I sure can, it is way past my bedtime but I am sure to be up early to check it. The workbook contains more, I am newbie so if you see anything silly, please ignore it! Again, thank you so much!

Thank you for your respond Narayan. The workbook is attached is it massive! The code that I am having issue with is I have created this code on PDData sheet and it needs to hide empty rows in FlatStage sheet. Application.ScreenUpdating = False Dim s As String For i = 1 To...

Hello everyone, I am a newbie to vba code and have created multiple sheets for a work purpose. I am struggling with one portion of it. I need to automatically hide empty rows on a different sheet (same workbook). The code I am using is giving me syntax error back and I cant seem to figure it...