User Profile

Collapse

Profile Sidebar

Collapse
auhom
auhom
Last Activity: Jul 24 '16, 03:17 PM
Joined: Jul 21 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 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 ?
    See more | Go to post

  • auhom
    started a topic Removing Blank Cell info when save as xml data

    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....
    See more | Go to post
    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!}]

  • auhom
    replied to Reverse page printing
    I have to print both pages, Everytime i print the front page i have to turn over the pages for printing
    See more | Go to post

    Leave a comment:


  • auhom
    started a topic Reverse page printing

    Reverse page printing

    How do i use reverse page printing
    See more | Go to post

  • 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...
    See more | Go to post
No activity results to display
Show More
Working...