User Profile
Collapse
-
Clear Contents of unprotected Specific Range in a protected sheet
I want to clear the unprotected contents of a protected sheet within a specific range. for example when i run VBA it will clear the contents ranging from A1002:F1301 and G1002: AZ1301. The mentioned ranges are unprotected. I want only the cell between these range to ne clear but not format or any other change . How can i do this ? -
Removing Blank Cell info when save as xml data
Sorry for posting an excel problem here
I am maintaining an excel sheet using references from other worksheet of a same workbook . I want to save the data as xml data. Problem is when i save is as xml data it counts all the blank cells too.
I have an excel document where some of the cells are empty When i save the excel as xml spreadcheet i get the row with all the data from the cells that have data and and the empty cells....Last edited by zmbd; Jul 24 '16, 12:36 AM. Reason: [z{in the future please do not double post your question}][z{inserted images, in the future please do not use images for text!}] -
I have to print both pages, Everytime i print the front page i have to turn over the pages for printing -
-
Report page chronology is not maintained with the data table
I am maintaining an excel sheet and i don't have much knowledge about access. For official purpose I have made a forwarding report in access report. When Paste data from excel sheet to access data table reports in the page is not shown chronologically . For instance Information of the First row should be shown in the first page of the report, then 2nd row in the second page(all are 1 page report) but the data shown in the 1st page of the report is...
No activity results to display
Show More
Leave a comment: