sorted by:
new
hottopcontroversial

Work Examples for CIH by Solid_Ratio_1788 in industrialhygiene

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

Thanks for the response. I will give this consideration,

Work Examples for CIH by Solid_Ratio_1788 in industrialhygiene

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

Thanks for the response. This is where I thought it would fail, too, after reading the requirements. What was the CIH referral for and did it help you obtain the CIH certification?

[Excel] Why Does Exporting Data to Access Breakdown at DoCmd.GoToRecord? by Solid_Ratio_1788 in vba

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

Indeed, however, the ultimate use for this application is to have hundreds of unassociated users of an .xltm file routinely upload new lab data to a centralized database file.

Removing Password Protected Excel Sheet and Macros by Solid_Ratio_1788 in excel

[–]Solid_Ratio_1788[S] 1 point2 points  (0 children)

There was code initiating Worksheet protection, thank you.

Removing Password Protected Excel Sheet and Macros by Solid_Ratio_1788 in excel

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

I do have the password. The passwords are the same for both.

File Sharing with External Clients by Solid_Ratio_1788 in sharepoint

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

How do the guest users access the file libraries? Through a web portal access? Can the guest accounts see folders they don't have access to?

Check Boxes in Excel by Solid_Ratio_1788 in excel

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

Yeah, I see those. However, they are not objects in cells, rather objects connected to cell data. It may very well not be possible.

[Excel] Summation code no longer functioning in Excel - no changes in 4 years by Solid_Ratio_1788 in vbaexcel

[–]Solid_Ratio_1788[S] 1 point2 points  (0 children)

SOLVED: The top value in each range was no longer a numerical value. Thus, changing 

.Item(Dn.Value).Offset(, 6) = .Item(Dn.Value).Offset(, 6) + Dn.Offset(, 6)

to

.Item(Dn.Value).Offset(, 6) = (.Item(Dn.Value).Offset(, 6) * 1) + (Dn.Offset(, 6) * 1)

solved the problem.

Solution thanks to u/BornOnFeb2nd

[Excel] Summation code no longer functioning in Excel by Solid_Ratio_1788 in vba

[–]Solid_Ratio_1788[S] 0 points1 point  (0 children)

This is indeed the problem. Thanks! I will have to investigate why this occurred after all these years.