I have data from A2 to I1000
Column A is Program Name and Column I is comment section
I have written the VBA code to filter each program and make updates in Web based system. AFter this I need to provide comment as "Completed" in Column I .
If filter select A3 to A18 as this belongs to one program then column range I3 to I18 should get filled with the comment "Completed". Basically based on filtered range the column I range should be updated with the "Completed" comment.
Thank you in Advance
Hi, rshnkmr39,
youz should try and add the following lines after the update (itīs you who must decide whether the update was successful or not)
where you should replace ActiveSheet with the name or the codename of the sheet in question.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks